Checking value of a check box on a report

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
 
R

Rick

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
 
D

Duane Hookom

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