Display a photo on a report

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

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,
 
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
 
Thanks Sam!!

Works like a bought one!!

Cheers,

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

Cheers,
 
Back
Top