How to Display Portrait and Landscape Photos Correctly in Access
Question details
The user needs a reliable way to properly display and print embedded photos in MS Access forms and reports while maintaining their correct portrait or landscape orientation.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Creating and distributing forms or reports containing embedded inspection photos across multiple databases.
- Observed behavior
- Images display with inconsistent and incorrect orientations across the form view, print preview, and the original source folder, making report distribution unsatisfactory.
Verify that your Access database is well below the 2 GB file size limit, especially if you are embedding multiple high-resolution photos directly into the tables.
Pre-process and Rotate Images Before Importing
Use external image editing software to permanently rotate and save photos in their correct orientation before embedding them into your Access database.
Microsoft Access often struggles to interpret EXIF orientation data attached to photos by digital cameras or smartphones. Rotating the images in a dedicated photo editor ensures the actual pixel data is re-oriented, forcing Access to display them correctly.
Navigate to the folder containing your images and open them using a batch image processor or a standard photo editing tool on your computer.
Rotate all sideways portrait and landscape photos to their intended viewing angles. Ensure you overwrite the files or save them as new copies to permanently apply the rotation.
Open your MS Access database, remove the incorrectly oriented OLE objects or attachments, and re-embed the newly saved, correctly oriented photos into your forms or reports.

Use a VBA Script or Sample Database Tool
Utilize custom VBA code or a trusted sample database tool to automatically identify and manipulate image orientation prior to printing.
Looking for a Lightweight Office Suite?
While Microsoft Access is built for complex relational databases, managing everyday data, lists, and images can often be handled much more efficiently using WPS Spreadsheet. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, offering intuitive tools for your daily tasks.
- 1. Download WPS Office: Visit the official WPS website and install the free office suite on your device.
- 2. Organize data in Spreadsheet: Create a new WPS Spreadsheet to manage records that don't strictly require a complex relational database setup.
- 3. Insert images seamlessly: Navigate to the Insert tab to add photos directly into cells or as floating objects, where they will maintain their intended orientation without script workarounds.

Frequently Asked Questions
Why do my photos rotate automatically when inserted into Access?
Access sometimes ignores the EXIF orientation metadata stored in the original image file. If a photo was shot vertically but the camera sensor recorded the raw pixels horizontally, Access may display it sideways despite it looking correct in Windows File Explorer.
How can I prevent my Access database from exceeding the 2 GB limit when storing photos?
Instead of embedding images directly into your tables as OLE objects or Attachments, store the file paths as short text fields and link to the external image files on your drive. This keeps the database size extremely small.
Can I manually rotate images directly inside an Access report?
No, Microsoft Access does not feature built-in image rotation controls for forms or reports. You must either rotate the images using external photo editing software before importing them, or use complex VBA code to manipulate the image controls dynamically.




