Others

How to Display Linked Images in a Microsoft Access Form

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 870 views

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.

How to Display and Browse Linked Images in an Access Form
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a related table for image paths

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.

2
Design the subform

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).

3
Add an Image Control

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.

4
Configure the On Current Event

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

5
Test the navigation

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.

Use a Subform and the On Current Event Procedure
Database Optimization: Using linked external images keeps your Access database highly optimized and protects you from hitting the 2GB file size limit inherent to Access files (.accdb).
Free Microsoft Office alternative

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. 1. Download WPS Office: Install WPS Office for free to access Spreadsheet, Writer, and Presentation tools.
  2. 2. Export your Access data: In Microsoft Access, export your tables or query results as an Excel Workbook or CSV file.
  3. 3. Analyze in WPS Spreadsheet: Open your exported data in WPS Spreadsheet to easily filter, chart, and analyze your records.
Fully compatible with Microsoft Excel (.xlsx) and CSV formats commonly exported from databases.100% free with a lightweight installation and no mandatory subscription fees.Familiar tabbed user interface ensures a seamless transition and zero learning curve.
microsoft office alternative - wps office

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.