Web Development

General discussion


Images in reports

By taylorc5150 ·
I have created an Access database at home for my sporting club and I have set up the players form to work as the Northwind Employees Form does with the image of the players linked to external files. My problem is that I want to create a report so that I can print out a membership card with the photo. Therefore I want to display the photo automatically in the report, I am having trouble in discovering how to do this in VBA in the report. Can anybody help me?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by AyukNotna In reply to Images in reports

...in your table

add another field, set the data type as "OLE Object" (this will hold the photo of each members).

...in your report

open the report, select "Bound Object Frame" from the toolbox, position the frame in your report, and presto you got your photo.

set the properties like:

control source = YourFieldName
size mode = stretch (to fit the photo in the box)

the rest as you desired.

hope this help.

Related Discussions

Related Forums