Check Box suppressed

  • Thread starter Thread starter Guest
  • Start date Start date
Please help James said:
How can I suppress the check box in a report if data is not checked (is
false)?
Click to expand...

Assuming your Check box is called chkSomething and the accompanying label is
lblSomething, in the Print event of the Section in which it appears, put the
following

Me.lblSomething.Visible = Me.chkSomething
Me.chkSomething.Visible = Me.chkSomething

That will set the visibility of both the Check Box and the Label to False if
the content is False, or True if the content is True.

Larry Linson
Microsoft Access MVP
 
Perfect...Thanks Larry!

Larry Linson said:
Assuming your Check box is called chkSomething and the accompanying label is
lblSomething, in the Print event of the Section in which it appears, put the
following

Me.lblSomething.Visible = Me.chkSomething
Me.chkSomething.Visible = Me.chkSomething

That will set the visibility of both the Check Box and the Label to False if
the content is False, or True if the content is True.

Larry Linson
Microsoft Access MVP
Click to expand...
 

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

How to suppress blank yes/no fields 0
suppress same information for the row 1
Suppress Check Box 2
2 related questions 5
How to suppress printing reports that contain no data is select fi 1
Suppressing Page Header for Specific Page 3
Suppress printing 2
suppress report detail 1

Back
Top