Blank fields in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
In the reports details section's format event:
if Me.Checkbox = True
Me.Checkbox.Visible = True
Else
Me.Checkbox.Visible = False
End If
 
Oops forgot the "Then":

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