Web Development

Ask something
Discussion Locked

Images in reports

0 helpful
1 reply

by taylorc5150

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by ayuknotna

...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.

This discussion is closed to new replies.