Others

Microsoft Access VBA: Display an Image from a File Path

Rana GarciaRana Garcia Nov 13, 2026 869 views

Question details

The user needs to display an image on a single-record Microsoft Access form when the database stores the image path and filename, and wants VBA code to pass the complete path to an image control.

Product
Microsoft Access
Device & OS
Windows
Scenario
An Access database table stores image paths, and the user wants the corresponding picture to appear on a single-record form automatically.
Observed behavior
The desired outcome is for the form image control to resolve the stored path and show the image, whether the path is stored as one field or split across path and filename fields.
Before you start

Confirm that each stored path includes the full image filename and that the file exists at that location. Open the Access form in Design View and make sure an unbound image control is available.

Solution 1Recommended

Set an Unbound Image Control to the Full File Path

Use this when the table stores the complete image path with filename in one field.

Microsoft Access image controls require the complete file path, including the image filename. Supplying only a folder path will not display the picture.

1
Open the form in Design View

Open the single-record form in Design View, then select the Image control or insert one from the Controls group.

2
Bind the image control to the path field

With the image control selected, open the Property Sheet and set Control Source to the field that stores the full image path, such as ImagePath.

3
Switch to Form View

Save the form and switch to Form View. Navigate between records to confirm the image displays for each stored path.

Full path required: Always include the image filename in the stored path, for example E:\media\Images\Food\Recipes\Blueberry Muffins.jpg.
Free Microsoft Office alternative

Manage Daily Office Tasks in WPS Office Without Access VBA

This issue belongs to Microsoft Access itself, and WPS Office does not fix Access forms or VBA. For everyday table, document, and presentation work, WPS Office is a free, lightweight Microsoft Office alternative that opens Word, Excel, and PowerPoint files with a familiar interface and easy migration.

  1. 1. Download WPS Office: Go to the official WPS Office download page and download the free installer for Windows, macOS, Android, or iOS.
  2. 2. Install and open WPS Spreadsheet: Install WPS Office, then open WPS Spreadsheet from the home screen to manage tables and image path data.
  3. 3. Open or create your file: Open an existing Microsoft Excel workbook or create a new spreadsheet to continue working with familiar Office file formats.
Manage image paths and tabular records in WPS Spreadsheet without Access VBA complexityOpens and saves Microsoft Excel, Word, and PowerPoint file formatsFree and lightweight with a familiar Office-style ribbon interfaceSeamless migration from Microsoft Office for routine documents and spreadsheets
QA img-9

Frequently Asked Questions

Why won't my Access image control show the image when I only provide the folder path?

Access needs the complete path including the image filename, such as E:\media\Images\Food\Recipes\Blueberry Muffins.jpg. Bind the image control Control Source to the field that contains that full path.

How can I combine the image folder and filename if they are stored separately?

Add a calculated field to the form's Record Source, for example FullImage: ImagePath & ImageFile, then set the image control Control Source to FullImage.

Can a user select an image from a file dialog and then display it on the Access form?

Yes. Use a VBA file picker function and assign the returned path to a text box with Me.txtImagePath = sFile. Then bind the image control to that text box or field.

Does WPS Office provide Microsoft Access or Access VBA forms?

No, WPS Office does not include an Access database application or Access VBA forms. You can use WPS Spreadsheet to manage tabular data and open Excel files as a free, lightweight alternative.