Report with photo

[SF]

Hi,

I have a create a report for printing ID. In the report I have an Image
control that would take the photopath from a photopath field.

I put the following code in the On Current event of the report

If IsNull(Me.Photo) Then
Me.Image5.Picture =
"S:\General\LAAR\Database\Photos\no_photo_available_large.png"
Else
Me.Image5.Picture = Me.Photo
End If

When I view the report, there is no photo display.

What is wrong with my code

SF

 

[Rob Parker]

I don't understand how you can have done that. A report (and any section of
a report) does not have an OnCurrent event.

The code itself seems OK; it should be in the OnFormat event of the section
of the report in which the image control is located.

HTH,

Rob

 

[Steve]

Access2007 does have an OnCurrent event. It's new. Access2007 can
interactwith the data in the report. You can browse from record to record
and when you click on a row in the report, the Current event fires. The
current event does not fire when the report opens like forms. The current
event also does not fire in Print Preview.

Steve
(e-mail address removed)