March 2nd, 2007, 11:23 PM
|
Member
|
|
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
|
|
Quote:
Originally Posted by Rick Brandt
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]
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
--
Worked like a charm. Thanks for the help
Jeff Monroe
|