Return of Yes/No Checkboxes

[Nick.Korynski]

I set up some coding in my form in access to populate an unbound field
automatically based on what values were entered in a series of
checkboxes. This seems to work great most of the time, however, I
noticed a few records for which it won't work. I started trying to
debug it and noticed that for these records, the checkboxes are
returning 0 for false and -1 for true. For the majority of my records
in which this works, they are returning true or false. What would make
these few records return different values? Thanks.

Nick

 

[fredg]

I set up some coding in my form in access to populate an unbound field
automatically based on what values were entered in a series of
checkboxes. This seems to work great most of the time, however, I
noticed a few records for which it won't work. I started trying to
debug it and noticed that for these records, the checkboxes are
returning 0 for false and -1 for true. For the majority of my records
in which this works, they are returning true or false. What would make
these few records return different values? Thanks.

Nick

The value of a check box in Access is either 0 or -1.
The value of False is 0. The value of True is -1.
So the actual value is the same whether it shows True or -1.

If you are having a problem with your code, then it would be helpful
to actually post your code, letting us know what you expect to happen
and what actually happens.