Problems with a form creation

[eedie]

I have received a Access Table consiting of the following fields and the data in those fields:

ProductNo: VER1001
ProductDescr: Pretty Item
Image: D:/Images/prettyitem.gif

The above describes the table fields and the type of data in them. The images is in a directory called Images.

Creating the form is OK, but all I see in the Image area is D:/Images/prettyitem.gif

How can I create a lookup from each record to display the image. If it was a OLE object, I could have done it, but not sure how to translate the image path?
Thank you for any help

eedie

 

[LonnieJohnson]

Do you have a continuous form or a single form? Is picture control an Image control or an Bound Object control? Is it possible to store the images themselves in your table vs the path to the image? If the path changes you link is lost. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[eedie]

This should realy be single forms.
There is no picture control or a Bound Object control.

The field in the table is a text field with only the path in it as text (D:/images/abc.gif) pointing to the dir where the images are stored.

So when I create a form, I see a field with D:/images/abc.gif being displayed. I want the form to lookup the image (D:/images/abc.gif) and display the image in this field

Eddie

 

[gusbrunston]

I don't think a text box will display an image. Why not insert a bound object control in design view. In form view right click on the control and either embed the image or link to it following the dialogue. There are advantages and disadvantages to embedding and linking. Unless you have hundreds and hundreds of pictures to insert, it's pretty simple. I've seen here references to programs that handle pictures in Access--might be worthwhile looking for something like that: automate the process and all that. Good luck.
Gus Brunston
An old PICKer
padregus@home.com