Yes/No field on report

[rkrause]

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]

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]

do you have any sample code for this? it seems rather simple but im still having issues.

 

[pbaldy]

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