How to Display Linked Images in a Microsoft Access Form
Question details
The user needs to display and navigate through multiple externally linked images within a Microsoft Access form to keep the database file size small.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Building a database form that needs to show images associated with records without bloating the database with OLE objects or native attachments.
- Observed behavior
- When attempting to link external images in a subform, only the text file path is displayed instead of rendering the actual picture.
Ensure all your external image files are saved in a stable, shared directory, and verify that the file paths stored in your database exactly match the current locations of these images.
Use a Subform and the On Current Event Procedure
This is the most effective method for displaying multiple external images per record. By using a subform linked to your main record and a simple VBA event, you can dynamically update an Image Control based on the selected file path.
Storing images directly in an Access database using the Attachment data type rapidly increases the database file size and degrades performance. Linking to external image files solves this but requires telling Access how to render the path as a picture.
By setting up a related table for image paths and utilizing the On Current event in a subform, Access will automatically load and display the correct image as you browse through records.
Create a new table (e.g., 'tblImages') linked to your main record's ID. Add a Short Text field named 'ImagePath' to store the exact file directory of each image.
Create a subform based on 'tblImages'. Open it in Design View and ensure the 'ImagePath' text box is present (it can be hidden if you prefer not to see the text string).
From the Form Design ribbon, select the Image Control and draw it onto your subform. If prompted to select a picture, click Cancel to leave it unbound. Name the control 'ImageControl' in the Property Sheet.
In the subform's Property Sheet, go to the Event tab, click on 'On Current', and open the Code Builder (...). Enter the following VBA code: Me.ImageControl.Picture = Me.ImagePath
Switch to Form View. As you navigate through the records in the subform, the Image Control will now dynamically read the text path and render the corresponding external image.

Bind an Image Control Directly (Access 2007 and later)
If you only need to display a single image per record, modern versions of Access allow you to bind an image control directly to a text field containing the file path without using VBA.
Manage Exported Database Records with WPS Office
While Microsoft Access handles backend database management, reporting and analyzing that data is often best done in spreadsheets. WPS Office is a free, lightweight, and easy-to-use alternative to Microsoft Office that offers seamless formatting for your exported database reports and lists.
- 1. Download WPS Office: Install WPS Office for free to access Spreadsheet, Writer, and Presentation tools.
- 2. Export your Access data: In Microsoft Access, export your tables or query results as an Excel Workbook or CSV file.
- 3. Analyze in WPS Spreadsheet: Open your exported data in WPS Spreadsheet to easily filter, chart, and analyze your records.

Frequently Asked Questions
Why do my linked images show up as text paths instead of pictures in my Access subform?
If you are only seeing the text path, it means the field is displayed as a standard Text Box. To show the image, you must insert an Image Control and use VBA (like the On Current event) to assign the text path to the Image Control's Picture property.
Does linking external images reduce Access database size?
Yes. Storing images directly inside Access using the Attachment data type or OLE Objects embeds the files into the database, which drastically inflates the file size. Linking external paths keeps the database strictly text-based and lightweight.
Can I display multiple images for a single record using this method?
Yes. By creating a separate related table to hold the image paths and displaying that table in a subform on your main form, you can scroll through multiple external images that belong to one parent record.




