Displaying Images in a Report

[Guest]

I have the Microsoft Access 2003 Bible which talks about displaying images in
a form.

Can you display images, specifically .jpg objects, in an Access report???

Any help would be GREATLY appreciated.

Thanks!

 

[M.L. Sco Scofield]

Just select the Image control from the toolbox when you have your report in
design view. The wizard will open the file dialog so that you can select an
image file.

For more information look up the image control in help.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Communications Director www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[fredg]

I have the Microsoft Access 2003 Bible which talks about displaying images in
a form.

Can you display images, specifically .jpg objects, in an Access report???

Any help would be GREATLY appreciated.

Thanks!

Sure.
Store all your pictures in a folder on your hard drive.
In your table, store just the picture name in a regular text field
named [PictureName].

Add an Image control to the report (in the Detail Section?)
You'll need to select any image picture to get the control to 'stick'.
Then delete the control's picture property.
Code the Detail Format event:
Me!ImageName.Picture = "c:\folderpath\" & [PictureName]

If the pictures are stored in various different folders, then include
the path to the folder in with the PictureName field in the table.
Change the above code to:
Me!ImageName.Picture = [PictureName]