Inserting Picture in Table for Form

I am creating a form that will make use of various graphic images (Line
Drawings) that I hope to create using some program such as Daw. I have added
an OLE field to the table, and included it as the data for a control that
takes up about half the screen on a form. When I open the form all I get are
two litttle boxes in the upper right hand corner of the control, and when I
click on the control, it says the text is too large to be edited.

This is the first time I have done anything like this. I am using Access
2000, and am fairly familiar with VBA if any coding is needed. Do I have to
reduce the image size? If so how do I do that with Daw? Is there something
other than Daw that I should be using?

Any help would be appreciated.

Frank Wagner
--
Frank Wagner

In order to display a bound OLE object you need a registered OLE server that
is associated with the filetype. I should also mention that storing images
in a database causes bloat at least to the file-size of the image, but can
be much larger. I suggest, storing a path to that image on your hard drive
in your table, and using an Image control in you form to display it. A
sample database that does just that and also allows you to collect and store
the paths is available at:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Frank Wagner" wrote in message
...
I am creating a form that will make use of various graphic images (Line
Drawings) that I hope to create using some program such as Daw. I have
added
an OLE field to the table, and included it as the data for a control that
takes up about half the screen on a form. When I open the form all I get
are
two litttle boxes in the upper right hand corner of the control, and when
I
click on the control, it says the text is too large to be edited.

This is the first time I have done anything like this. I am using Access
2000, and am fairly familiar with VBA if any coding is needed. Do I have
to
reduce the image size? If so how do I do that with Daw? Is there
something
other than Daw that I should be using?

Any help would be appreciated.

Frank Wagner
--
Frank Wagner

Thanks. I appreciate your comments regarding bloating the database.

With regard to showing the pictures, I ended up using auto form to create a
form over the table that had the picture imbedded. It automatically created
the type of control that was needed to show the picture.

Thanks again
--
Frank Wagner



"Frank Wagner" wrote:

I am creating a form that will make use of various graphic images (Line
Drawings) that I hope to create using some program such as Daw. I have added
an OLE field to the table, and included it as the data for a control that
takes up about half the screen on a form. When I open the form all I get are
two litttle boxes in the upper right hand corner of the control, and when I
click on the control, it says the text is too large to be edited.

This is the first time I have done anything like this. I am using Access
2000, and am fairly familiar with VBA if any coding is needed. Do I have to
reduce the image size? If so how do I do that with Daw? Is there something
other than Daw that I should be using?

Any help would be appreciated.

Frank Wagner
--
Frank Wagner