Blank fields in reports

[Guest]

Is there a way not to print fields in reports that do not have any data?
I've developed a form with checkboxes where the user either checks the box
for "yes" or leaves it blank for "no". Is there a way to print only the
boxes that contain a check box on my report? I don't want to see the blank
records?

Thank you.

 

[SusanV]

In the reports details section's format event:
if Me.Checkbox = True
Me.Checkbox.Visible = True
Else
Me.Checkbox.Visible = False
End If

 

[SusanV]

Oops forgot the "Then":

if Me.Checkbox = True Then
Me.Checkbox.Visible = True
Else
Me.Checkbox.Visible = False
End If

 

[Guest]

Perfect! This is exactly what I was looking for. Thank you.

 

[SusanV]

Glad to help when I can!

;-)

Perfect! This is exactly what I was looking for. Thank you.