Option Group results on reports

[Virginia]

Hi,

Am sure there must be an easy way to do this and I'm completely missing it!
I've just worked out how to set up option groups on a form to populate a
field on a table. So they just click either yes or no. I need to put the
Yes or No fields on a report in two columns with their choice ticked
underneath, but don't know how to get their choice into the two boxes. I
tried an iif command that doesn't work at all?

Any help please?

 

[Allen Browne]

You have a Yes/No field in a table, and you are using an option group to
interface it. So you have 2 option buttons in the group. The Yes button has
an Option Value of -1 (which Access uses for True), and the No button has an
Option Value of 0 (which is False.)

Now you want to show this yes/no field on a report in 2 columns. Say the
field is named MyYesNo. You probably already have the Yes column worked out:
you just put the MyYesNo check box in that column, and it checks correctly.

To create the other column, add another check box, and set its Control
Source to:
=Not [MyYesNo]
That's it.

If you want more control over how the 2 columns look (e.g. unboxed check
marks, or checks and crosses in the 2 columns), see:
Format Check boxes on reports
at:
http://allenbrowne.com/ser-52.html