Yes/No Control

[Orcanut]

I have a report that has a Yes/No control. I would like a result only to print when the control value is -1 (Yes). For No I would like to leave the text box blank.

More emphasis is afforded if the "Nos" are blank than when I try to find the "Yeses" amongst a sea of "Nos" but I can't seem to get the coding right.

Have tried IIf([xxx])=0,Str("""&quot,-1) in numerous combinations and none work.

Thanks for any help

Jim Baird

 

[CosmoKramer]

Jim,

In the On format event of the section where the field is you want to suppress, put code something like this:

If [YesNoField] = -1 Then
   txtFieldToShow.Visible = True
Else
   txtFieldToShow.Visible = False
End If

 

[Orcanut]

Thank you Cosmo. Live and learn.

Jim