Microsoft Access VBA: Display an Image from a File Path
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.
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.
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.
Open the single-record form in Design View, then select the Image control or insert one from the Controls group.
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.
Save the form and switch to Form View. Navigate between records to confirm the image displays for each stored path.
Concatenate Separate Path and Filename Fields in the Record Source
Use this when the folder path and image filename are stored in separate fields.
Use a VBA File Picker to Save the Selected Image Path to a Text Box
Use this when users need to select an image from a dialog and store its full path for display.
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. Download WPS Office: Go to the official WPS Office download page and download the free installer for Windows, macOS, Android, or iOS.
- 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. Open or create your file: Open an existing Microsoft Excel workbook or create a new spreadsheet to continue working with familiar Office file formats.

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.




