Formatting Issues

How to Display Portrait and Landscape Photos Correctly in Access

Aamir Naveed AkramAamir Naveed Akram Nov 3, 2026 870 views

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.

How to Display Portrait and Landscape Photos Correctly in Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Open your source photos

Navigate to the folder containing your images and open them using a batch image processor or a standard photo editing tool on your computer.

2
Correct the orientation

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.

3
Re-import to Access

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.

Pre-process and Rotate Images Before Importing
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and install the free office suite on your device.
  2. 2. Organize data in Spreadsheet: Create a new WPS Spreadsheet to manage records that don't strictly require a complex relational database setup.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily insert, manage, and preserve the correct orientation of images embedded directly in spreadsheet cells.Lightweight installation with an intuitive, familiar user interface that makes migrating seamless.
microsoft office alternative - wps office

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.