insert picture based on field value

  • Thread starter Thread starter klkropf
  • Start date Start date
K

klkropf

I am trying to insert a picture in a report, but only if the value of a
specific field is correct. This is what I currently have.

If Len(Me.ImageGlobePath & "") > 0 And Me.Global_US = "G" Then
Me.GlobeImage.Picture = Me.ImageGlobePath
Else
Me.GlobeImage.Picture = "C:\Pictures\blank.bmp"
End If

But when this runs as soon as it come across an employee with Global_US
equal to "G" then it inserts the picture for every record after that even if
it isn't equal to "G".
 
It ought to work, so long as you have the correct file path, file name and
file extension of Blank.bmp.
Have you got this code in the On Format event of the section that contains
the Image frame?

Evi
 
Back
Top