Display a photo on a report

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


"DontKnow" wrote in message
...
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,

Thanks Sam!!

Works like a bought one!!

Cheers,

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

Cheers,

"Sam Davis" wrote:

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" wrote in message
...
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,