Access 2003 or earlier
How to display an image from a folder in a form or in a report
SUMMARY
Sometimes, it is not practical to store images in a Microsoft Access table. If you have
many images, or if each of your image files is large, the size of the Microsoft Access
database file can quickly increase.
This article demonstrates a custom function that you can use to: • Store file paths and
names of images in a table.
• Display images by using an image control.
• Hide the image control if no image is available.
• Provide feedback on the display status of the image.
This article also contains sample Visual Basic script that you can use to display the
images in a data access page.
Access 97 - http://support.microsoft.com/kb/148463/EN-US/
Access 2000 - http://support.microsoft.com/kb/210100/en-us
Access 2002/2003 - http://support.microsoft.com/kb/285820/