Yes/No Box

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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
 
Back
Top