IIF statement in access reports. 1

[frankcpl]

I am trying to check a yes no field and display Personal and Business.

I have tried If, Then Statement

And tried IIF statement. Neither is working. Could someone look at this and give a hand in figuring out why it will not work.

I create an unbound label named Typelbl. I am referencing a Yes/No box.

If Yes/No.value = Yes Then
Typelbl.Caption = Personal
Else
Typelbl.Caption = Business
Endif

This doesn't work and I have also tried:

=IIF([Yes/No]="yes","Personal","Business")
That still didn't work.

I have tried putting the code in the report open(), Label AfterUpdate() and a variety of other places and still it isn't working.

 

[dhookom]

Have you tried changing the label to a text box and using:

  =IIF([Yes/No],"Personal","Business")

Duane
Hook'D on Access
MS Access MVP

 

[frankcpl]

OMG!!!! I fill so stupid. I never even thought of using a text box.

Thank you very much for your help I have messed with this thing for hours and never once tried it in a text box.

Again, Thank you.