If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yes/No Boxes on Reports
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 |
#2
|
|||
|
|||
Yes/No Boxes on Reports
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 |
#3
|
|||
|
|||
Quote:
Worked like a charm. Thanks for the help Jeff Monroe |
Thread Tools | |
Display Modes | |
|
|