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)
 
Back
Top