Yes/No Box

G

Guest

Is there a way that if the YES/NO box is checked that a 1 is placed in the
field and if not checked a zero is placed in same field. I have worked with
an IIF statement and I guess I am doing it wrong. Or would a true/false,
no/off be better?

Thanks again in advance for the help.
 
A

Al Camp

Daniell,
A Yes/No, True/False field is Boolean, so checked = -1 and not checked = 0
So, if you use the absolute function...
Abs(YourYesNoField)
the result is either 1 or 0.
 
R

Ron2006

That is the test, but now the question is where are you putting the
test. On what field and/or on what events.

You may have the test correct, but if the test is NOT being executed,
it will NOT help you any.

Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Labels in Reports if Field Blank 2
IIf statement and check boxes 4
Query Criteria IIf statement 4
Too many IIF statements 3
sum of check box 2
Yes/No export appearance 1
Complicated IIf Statement Problem 24
Access 2010 0

Top