Yes/No Boxes on Reports

[Jeff Monroe]

I have a report where I would like display two check-boxes like this:

Required? Yes[] No[]

In the data entry form, the input is a standard Yes/No check-box. If
the user inserts a check, it means "yes"; un-checked means "no".

How can I display this on the report (when viewed), that when the box
was checked, the "Yes" box is checked, conversely when un-checked the
report's "No" box is checked. It's either one or the other.

Thanks.
Jeff

 

[Rick Brandt]

I have a report where I would like display two check-boxes like this:

Required? Yes[] No[]

In the data entry form, the input is a standard Yes/No check-box. If
the user inserts a check, it means "yes"; un-checked means "no".

How can I display this on the report (when viewed), that when the box
was checked, the "Yes" box is checked, conversely when un-checked the
report's "No" box is checked. It's either one or the other.

Thanks.
Jeff

Bind the "Yes" checkbox directly to your field. For the "No" checkbox use a
ControlSource expression of...

=Not [FieldName]

 

[Jeff Monroe]

Jeff Monroe wrote:-
I have a report where I would like display two check-boxes like this:

Required? Yes[] No[]

In the data entry form, the input is a standard Yes/No check-box. If
the user inserts a check, it means "yes"; un-checked means "no".

How can I display this on the report (when viewed), that when the box
was checked, the "Yes" box is checked, conversely when un-checked the
report's "No" box is checked. It's either one or the other.

Thanks.
Jeff-

Bind the "Yes" checkbox directly to your field. For the "No" checkbox
use a
ControlSource expression of...

=Not [FieldName]