Displaying Jpegs on form.

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...
 
F

Fred

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.
 
R

RJamis

Thanks. I did get that answer from another user in another forum.
Thank you for your time answering my post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top