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.
 
You must log in or register to reply here.

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

Check Box On Condition 1
Report based on check box and list box... 4
Sum Check Box 5
check box 3
CHECK BOX 1
Check List Report 4
Check box value in report 1
Spaces Between Check Boxes 2

Back
Top