Displaying Jpegs on form.

  • Thread starter Thread starter RJamis
  • Start date Start date
R

RJamis

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...
 
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.
 
Thanks. I did get that answer from another user in another forum.
Thank you for your time answering my post.
 
Back
Top