Check Boxes in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What should I include as the control source for a check box on a report?

I have a table that stores the 'yes' or 'no' result of a check box on a form
and I want to include it on a report. Not sure how!

Thanks
 
Are you using a checkbox on your form for the user to check or uncheck, but
really storing a Text "Yes" or "No" in a text field?? (ex. field =
MyYesNoField)

If so, then on your report, use a calculated ControlSource for your checkbox
of...
=IIF(MyYesNoField = "Yes", True, False)

But, if MyYesNoField is defined in your table as Boolean (Yes/No type), and
MyYesNoField is the ControlSource for your checkbox on your form, then place
a checkbox on your report and give it a ControlSource of MyYesNoField.
This is the preferred method...

hth
Al Camp
 
Robert said:
What should I include as the control source for a check box on a report?

I have a table that stores the 'yes' or 'no' result of a check box on a form
and I want to include it on a report. Not sure how!
Click to expand...


I don't understand the problem. A check box on a report
displays the same way it does on a form.

What have you tried and what result did you get?
 
Back
Top