Checking value of a check box on a report

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a report where i want to display a text box only
when a check box is marked true. I can program the
textbox to be visible or not. However, how do I check the
check box state to see if it is set or not?

Tim
 
If [CheckBox1] = true then...



I have a report where i want to display a text box only
when a check box is marked true. I can program the
textbox to be visible or not. However, how do I check the
check box state to see if it is set or not?

Tim
 
I wouldn't use code. Set the control source to:
=IIf(YesNoField, [FieldToShow], "")
Make sure the name of the control is not the name of a field.
 
Back
Top