How to Display Multiple Access Attachments in a Form or Report
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.

- 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.
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.
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.
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.
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.
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.
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).
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.
Bind the Control to the FileData Element
If you must use the native Attachment field, you can attempt to access the underlying FileData property, though it still carries display limitations.
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. Download the Installer: Visit the official WPS Office website and click the download button to get the free installation package.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen prompts to set up WPS Office on your computer.
- 3. Open Your Files: Launch WPS Office and open your existing Word, Excel, or PowerPoint documents effortlessly.

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.




