View Single Post
  #3  
Old March 2nd, 2007, 11:23 PM
Jeff Monroe Jeff Monroe is offline
Member
 
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default

Quote:
Originally Posted by Rick Brandt View Post
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