Check mark

[UT227]

I have a report where I have a yes/no field. I need the report to have 2 check marks. One has to be "Yes" and the other "No". However, my table only has the one field which is yes/no. I'm trying to find a way to populate the "No" check mark if the the "Yes" check mark is null. Ideas?

[ranman256]

no, 1 check box is either YES or NO.
checked means yes....unchecked means no.
the checkbox is bound to 1 field with a field type of boolean (yes or no, aka true/false, aka on/off)

you dont (and cant) have 2 checks.

[June7]

Your requirement doesn't really make sense. If there is no field then what purpose does the second checkbox serve?

You can have a textbox bound to yes/no field and format to display "Yes" or "No".

However, as ranman said, yes/no field is either yes or no, never Null.

[isladogs]

The OP wants to have two separate checkboxes for the same field so that one or other is ticked
So if the user ticks Yes, No is automatically unticked (& vice versa)
An odd way of doing things but it should be perfectly possible

However I think it will confuse end users rather than help them

[UT227]

I'm not sure I'm being clear about what I'm trying to do. The report is purely aesthetics for those who think it should look a certain way. My form enters everything fine. However, to please those that want to see the report in a particular format, I'm trying to keep it just so. I have 2 yes/no fields on my report. Only 1 actually carries any information. The second has no control at all. What I'm trying to accomplish is to make it so that if field 1 is 0, the one with no control sees it and puts a check mark, yes, -1, true.... I tried to put in; =if [field1],false,true That didn't work. I tried =if [field1],-1,0 That also didn't work either. I was hoping someone might have another possibility.

[UT227]

Ridders, yes. That's exactly what I'm trying to do. I know it's strange, but that's how they want it. People like their check marks.

[isladogs]

In other words, roughly what I suggested

Its easy enough to achieve in a form
Set the first control bound to your yes/no field e.g. [Field1]
Set the control source for the second checkbox equal to

=Not([Field1])

If the first is checked, the second won't be ...and vice versa
Ticking the unchecked one will toggle the checkboxes ... no code needed

Tested in a form
Reports are not really intended to be interactive
I don't think it is possible to update checkboxes for a report in report view

[UT227]

It was exactly like you suggested. It worked perfectly in a report too. That was great. Thanks.

[isladogs]

You're welcome. Glad the report also worked though I didn't expect it would do so.

[June7]

I expect OP is not clicking on the bound checkbox in report, just conditionally displaying value of second checkbox. Certainly nothing unusual about using expressions in report design, it's just this checkbox arrangement is odd.

[isladogs]

The reason I was surprised is that I also tested it using a report in report view before I posted - it wasn't possible to update them
As I originally said, the method is perfectly simple to apply but IMO confusing for end users