Others

How to Display Multiple Access Attachments in a Form or Report

Nimra MalikNimra Malik Nov 4, 2026 869 views

Question details

The user needs a way to display all images attached to a single record simultaneously within an Access form or report, primarily to ensure all images are visible at once when printing.

How to Display Multiple Access Attachments in a Form or Report
Product
Microsoft Access
Device & OS
not provided
Scenario
Designing a printable report or form in Microsoft Access where a single record contains multiple attached images that must all be visible.
Observed behavior
The default Access Attachment control only displays one picture at a time and requires the user to click navigation arrows to see others, preventing multiple images from printing together.
Before you start

Ensure you have a backup of your Access database before modifying table structures or writing VBA code. Consider creating a dedicated shared folder on your local drive or network to store image files before restructuring your data.

Solution 1Recommended

Use a Related Table and Subreport for Multiple Images

The most robust method to display multiple images at once and prevent database bloat is storing image paths externally and displaying them via a subreport.

By default, Access Attachment fields store data internally and only display one file at a time. To show all images simultaneously for printing, you should normalize your database by creating a one-to-many related table that stores external file paths instead of the actual files.

1
Create a Related Table

In Access, create a new table (e.g., tblRecordImages) linked to your main table via a foreign key. Add a Short Text field to store the external image file paths.

2
Store Images Externally

Move your physical image files to a shared local or network folder instead of uploading them directly into the Access database using the Attachment data type.

3
Create a Continuous Subform or Subreport

Design a continuous subreport bound to your new tblRecordImages table. Insert an Image Control from the Design ribbon into the Detail section of the subreport.

4
Link Images via VBA

Open the subreport's VBA module. Use the On Format (for reports) or On Current (for forms) event to dynamically set the Image control's Picture property to the file path stored in the record (e.g., Me.ImageControl.Picture = Me.ImagePathField).

5
Embed the Subreport

Open your main form or report in Design View, and drag the newly created subreport onto it. All linked images for a single record will now display simultaneously as a list.

Prevent Database Bloat: Storing images externally in a folder rather than embedding them directly significantly reduces the risk of your Access database hitting the strict 2GB maximum file size limit.
Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While WPS Office does not include a database management tool like Microsoft Access, it serves as a powerful, free alternative for handling your Word, Excel, and PowerPoint tasks. Enjoy a lightweight installation, an intuitive tabbed interface, and robust format compatibility for all your daily document needs.

  1. 1. Download the Installer: Visit the official WPS Office website and click the download button to get the free installation package.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen prompts to set up WPS Office on your computer.
  3. 3. Open Your Files: Launch WPS Office and open your existing Word, Excel, or PowerPoint documents effortlessly.
Fully compatible with Microsoft Office formats, seamlessly opening .docx, .xlsx, and .pptx files.Lightweight software architecture that runs smoothly and quickly on older and newer devices alike.Features a familiar tabbed user interface to ensure a seamless transition from Microsoft Office.Includes a built-in comprehensive PDF toolkit for viewing, editing, and converting files easily.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Access Attachment control only show one image at a time?

By design, the native Attachment control in Microsoft Access is built to display a single file at a time. It provides built-in navigation arrows to let users cycle through multiple attached files manually, which prevents them from being displayed side-by-side or printed simultaneously.

Does storing images directly in an Access database slow it down?

Yes, embedding files using the Attachment data type increases the overall database file size very quickly. Large databases can suffer from performance degradation, slower load times, and risk hitting the strict 2GB file size limit inherent to Microsoft Access databases.

How do I dynamically load external images into an Access report?

You can load external images by adding an Unbound Image control to your report. In the VBA editor, use the report's Detail_Format event to set the Me.YourImageControlName.Picture property to the file path string stored in your underlying data table.