How to hide blank check box on access report

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

Guest

How do I hid e blank check box in an access report... the other fields only
print if populated... but box always prints... I tried making the border
transparent...
 
On the "on print" event of the section where the check box is placed enter
the code

If me.checkbox = false then
me.checkbox.visible=false
else
me.checkbox.visible=false
end if
 
Put the following code in the Detail's Format event:
Me!NameOfCheckBox.Visible = Not IsNull(Me!NameOfCheckBox)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide check boxes in a report 3
Access, hide blank fields AND Captions 4
hiding boxes but pring blank pages 1
Check box format option 2
blank fields on a name line 2
Printer quit printing check boxes in my MS Access Report 2
email a report with formatting to word for editing 1
Printing Blank Records to Complete a Report 18

Back
Top