Check Box suppressed

  • Thread starter Please help James
  • Start date
P

Please help James

How can I suppress the check box in a report if data is not checked (is false)?
 
L

Larry Linson

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
 
P

Please help James

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...
 
Top