Displaying stored jpgs as pictures in a report

[BlueWolverine]

hello,
MS ACCESS 2003 on XP PRO

I've never stored jpgs in a table before, but now I apparently need to.

I figured out (i think) how to store a jpg in a table using OLE OBJECT data
type.

But when I try to make a report of that ttable, the picture displays as a
box with the file name displayed as text. How can I get the image to display
on the report?

Thank you,

 

[golfinray]

Try using an UNbound object frame and inserting the jpg in it.

 

[Steve]

Store your .jpgs in their own folder. Store the complete paths to your .jpgs
in your table in a text field. Then to display the .jpgs in your report, use
an image control and set the picture property of the image control to the
path of the .jpg.

Steve
(e-mail address removed)

 

[Gina Whipp]

BlueWolverine,

Try this link which has MANY samples of how to insert/display images in
forms and reports.

http://www.granite.ab.ca/access/imagehandling.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm