iif statement.

[pekajo]

Hi,
I am trying to print business cards but need to 'switch' off the logo (image) depending on the field [Surname]. (Please see attached jpg)

My iif statement is as follows which I have placed in the image Control Source.

iif([Surname] = "a",[Image42].visible = False)

However it does not work.
Any ideas
Peter

 

[theDBguy]

Hi. The IIf() function returns a value. You can’t use it to return a code statement.

 

[arnelgp]

add code to the Report's Detail section: Format event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.[Image42].Visible = (Me.[SurName] <> "a")
End Sub

 

[pekajo]

Hi,

Thanks for the reply. Entered as suggested. And got the attached error. I tried changing the image and is now image49

Me.[Image49].Visible = (Me.[Surname] <> "a")

Is it something I have typed?

Peter

 

[arnelgp]

check the Textbox name and image name if correct, then rectify.

 

[pekajo]

Hi,
Double checked so thought I would go the whole hog and add Reports!Reportname!image....
worked like a charm.

Thanks for you help.
Peter

 

[theDBguy]

Hi,
Double checked so thought I would go the whole hog and add Reports!Reportname!image....
worked like a charm.

Thanks for you help.
Peter

Hi Peter. Glad to hear you got it sorted out. Good luck with your project.