Others

Display Vehicle Pictures in a Microsoft Access Subform

Nimra MalikNimra Malik Nov 20, 2026 868 views

Question details

The user wants to display small vehicle-type pictures alongside records in an Access subform.

Display Vehicle Pictures in a Microsoft Access Subform
Product
Microsoft Access
Device & OS
not provided
Scenario
A subform lists vehicles or vehicle types, and each record should show its corresponding picture.
Observed behavior
The subform is in Datasheet view, which does not display the pictures as image controls.
Before you start

Identify the field that links each vehicle record to its vehicle type. If you plan to use external pictures, make sure their file paths are accessible to everyone who will use the database.

Solution 1Recommended

Show external vehicle pictures in a continuous subform

Use this method when you can store a picture path for each vehicle type instead of embedding the pictures in the database.

1
Add picture paths

Open the vehicle-type table in Design View and add a Short Text field for the picture path. In Datasheet View, enter the full path and filename for each type's picture.

2
Include the path in the subform

Open the subform in Design View and set its Record Source to a table or query that includes the vehicle records and the matching picture-path field, joined by vehicle type.

3
Switch the form view

In the subform's Property Sheet, select the Form object and set Default View to Continuous Forms.

4
Bind an image control

On the Design tab, add an Image control to the Detail section. In the control's Property Sheet, set Control Source to the picture-path field and size the control for a small picture.

5
Check the subform

Save the subform and open the parent form in Form View. Check that each row displays the picture for its vehicle type and that the paths are accessible.

Show external vehicle pictures in a continuous subform
Keep picture paths accessible: If picture files are moved or a path is unavailable on another computer, Access cannot display those pictures until the stored paths are corrected.
Free Microsoft Office alternative

Work with Office documents in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Its format support makes it easy to move everyday files from Microsoft Office. WPS Office does not replace Access or fix Access subforms.

Work with vehicle lists and images in spreadsheetsOpen and edit Microsoft Excel XLSX and Word DOCX filesUse familiar document and spreadsheet toolsMove everyday Office files to a lightweight, free suite
microsoft office alternative - wps office

Frequently Asked Questions

Can an Access datasheet show pictures in a column?

A form or subform in Datasheet view does not display pictures through image controls. Switch the subform's Default View to Continuous Forms and add an image control or bound object frame to its Detail section.

How does Access select the correct picture for each vehicle?

Include the picture field in the subform's Record Source, using a query that joins vehicle records to the vehicle-type table. Bind the image control or object frame to that field.

Why is my image control blank?

Check the control's Control Source in the Property Sheet and confirm that the field contains a valid picture path. Also check that the file is accessible from the computer running Access.

What happens if I move an external picture file?

The stored path will no longer point to the picture. Update the Short Text field with the file's new path and filename.