Hide Yes No Check Box

[Brogrim]

I have a table with 5 YES NO Fields. On the report the yes no field show as check boxes.

If the check box is not true I don't want it visible on the report. I am trying an IF statement on the open event of the report

If txtNew = 0 then
txtnew.visible = False

This does not work, any ideas's apprecitaed

 

[smedvid]

I think u want that code in the Print/Format Event Section... Try it there... Make sure u are in the DEtail Section where the fields appear. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[CosmoKramer]

Also, don't forget to account for txtNew being = 1:

If txtNew = 0 then
   txtNew.Visible = False
[COLOR=blue]Else
   txtNew.Visible = True
End[/color]

With the original code, if the first txtNew is 0, it's not visible. If the second txtNew is 1, it's still not visible.....

Hoc nomen meum verum non est.