Display a photo on a report

[DontKnow]

Hi Guys,

I want to be able to display a photo (.JPG) on a report. I have all of the
Photos outside of the database to prevent excessicve bloating and to maintain
the size of the database. I currently am able to display the photo on a form
but would like to know how to do it on a report?

is there a particular method I need to utilise. ??

Please help me!

Here is the code for the forms that I have used which works beautiofully:
Set db = CurrentDb
filename = db.Name
pathname = Mid(filename, 1, Len(filename) - Len(Dir(filename)))


Dim personname As String
personname = Me.Firstname & " " & Me.Surname
personname = personname & ".JPG"
Me.Image16.Picture = pathname & personname

How would I modify this for the reports??
Cheers,

 

[Sam Davis]

Hi,

Assuming your form code works, it should also work on a report. Use the
Print event for the relevant report section to set the Picture property of
an image control just like you have for the form.

HTH
Sam

 

[DontKnow]

Thanks Sam!!

Works like a bought one!!

Cheers,

The key to the success was utilising the "Print event"

Cheers,