Imbed JPG Images into Access 2007 Record

[Andy]

We have an access DB that will have a different JPG image for each record. We
want that image to show each time that specific record is opened. We will
also want the image to print with a inventory report.

Is that possible? If so how? I have looked at the various OLE informaton but
it isn't very clear.

 

[Fred]

The best way is to store them in a separate folder, and store that location
and file name in 1 or 2 text fields, and use code to display them in forms
and reports.

Up through 2003 that was the only viab way. With 2007 I heard that
embedding them in the table is viable if your image content is small. I'm
not fluent on that because I switched from 2007 to 2003.

 

[Kent]

Hi Andy
Store the path to each image in a field then add an image control to your
form. Set its Size Mode to Zoom. Then in the On Current event populate the
image control with the image eg
Me.imgControl.Picture = Me.txtImagePath.