Others

How to Display Images from a Folder in Microsoft Access

Ayan Masood Oct 10, 2026 869 views

Question details

The user wants to know how to connect and display images stored in a local folder (such as C:\NEPhotos) on a Microsoft Access form.

How to Display Images from a Folder in Microsoft Access

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing an Access form that needs to display images saved in a local directory without storing the actual image files inside the database to save space.
Observed behavior: The user needs to correctly configure the image control to load the external image file without relying on unnecessary database connections like ODBC.

Before you start

Ensure you have the exact file path of the folder where your images are stored on your local drive, and verify that the images are saved in a standard format such as .jpg or .png.

Solution 1Recommended

Assign a Full File Path to the Access Image Control

The most straightforward way to display local images is by assigning the absolute file path directly to an image control on your Access form.

You do not need an ODBC connection or a query wizard to display local image files. Instead, Access requires the complete file specification—including the drive letter, folder path, file name, and file extension—to locate and display the image.

Open Form Design View

Open your Microsoft Access database, right-click the form where you want to display the image, and select 'Design View'.

Insert Image Control

From the Form Design tools ribbon, click on the 'Image' control icon and draw it onto your form canvas.

Set the Picture Property

Open the Property Sheet for the newly added Image Control. In the 'Picture' property field, enter the complete file path of the image (for example, C:\NEPhotos\photo1.jpg).

Verify in Form View

Switch the form back to 'Form View' to verify that the image loads and displays correctly on the screen.

Assign a Full File Path to the Access Image Control

Dynamic Images using VBA: To change images dynamically as you navigate through different records, use a VBA variable containing the full path and assign it to the image control's Picture property during the form's 'On Current' event.

Solution 2

Verify File Properties and Path Accuracy

If the image control displays a blank box or an error, the issue is typically caused by an incorrect file path or mismatched file extension.

Free Microsoft Office alternative

Looking for a Lightweight Alternative to Microsoft Office?

While WPS Office does not include a relational database management tool like MS Access, it is a fantastic, free alternative for Word, Excel, and PowerPoint tasks. If you frequently export data or reports from databases, WPS Spreadsheet offers powerful data analysis tools with full compatibility for Microsoft Office formats.

1. Download WPS Office: Download and install WPS Office Free from the official website.
2. Export Database Data: Export your database tables or query reports to a standard CSV or Excel (.xlsx) format.
3. Analyze in WPS Spreadsheet: Open the exported files in WPS Spreadsheet to easily analyze, format, and present your data.

Free, lightweight, and fast Office suiteFully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsSeamlessly handle CSV and Excel data exports from database applicationsFamiliar, user-friendly tabbed interface for easy migration

microsoft office alternative - wps office

Frequently Asked Questions

Do I need an ODBC connection to display images from a local folder in Access?

No, an ODBC connection is unnecessary for displaying local images. ODBC is primarily used for connecting to external database records. Local images are standalone files that only require a valid file path to be displayed in an Access image control.

How do I dynamically change the image based on the current database record?

You can dynamically assign the image path by storing the file path as text in a database table field. Then, use VBA on the form's 'On Current' event to read that text field and set the Image Control's Picture property to match the corresponding file path.

Why is my Access form showing a blank box instead of the picture?

This usually occurs if the file path is misspelled, the file was moved or deleted, or the file extension is incorrect. Right-click the original image in Windows File Explorer, check its Properties, and verify that the exact location path and extension match your Access form configuration.

Office Quick Solutions