rkrause
01-05-2010, 01:00 PM
I have a yes/no field on a report. on the report its a checkbox. So if the field is yes,theres a check in the box, if now its blank. How can i have it so that if its yes it shows, if not its not on the report?
Thanks.
pbaldy
01-05-2010, 01:59 PM
You could do it with code in the format event of the section containing the checkbox. Test the field and make the checkbox visible or not appropriately.
rkrause
01-05-2010, 03:06 PM
do you have any sample code for this? it seems rather simple but im still having issues.
pbaldy
01-05-2010, 05:01 PM
Long but more intuitive version:
If Me.CheckboxName = True Then
Me.CheckboxName.Visible = True
Else
Me.CheckboxName.Visible = False
End If
Short version:
Me.CheckboxName.Visible = Me.CheckboxName