Displaying Jpegs on form.

External Since: Feb 28, 2009 Posts: 2

Greetings,
I'm using Access 2003.
Have created small DB with the following fields:
InventoryID
Stock # - Text Field (Primary Key)
Description - Text
Bin Location - Text
Image - OLE Object

Created Form Using Wizard.
I right click on the OLE Object Control then select Insert Object.
On Dialog box, I check the Creat from file radio button.
I browse to the JPG file then Dbl Click.
The Picture appears in control but also has file name in the control.

Have changed various properties with no success.
how can I get rid of the file name?

Thanks...

External Since: Jun 26, 2006 Posts: 510

You might want to do a search in this forum on the topic of storing and using
images in your application. Basically everybody says that (at least through
2003, possibly beyond) to not do what you're doing (using OLE field) because
it has too many problems. Instead store it separately, store the file name
and path in 1 or 2 text fields, use code to use/view the image (i.e. in a
form or report) and gives details on how to do that.