Display Vehicle Pictures in a Microsoft Access Subform
Question details
The user wants to display small vehicle-type pictures alongside records in an 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.
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.
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.
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.
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.
In the subform's Property Sheet, select the Form object and set Default View to Continuous Forms.
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.
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 embedded pictures with a bound object frame
Use an OLE Object field when you want to store pictures in the database rather than refer to external files.
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.

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.




