checkboxes in Access 2002 only return -1 and 0

J

johnq1

I'm really confused, why do the checkboxes in Access 2002 only return -1 and
0. I really need 1 for "yes" and could use "n/a". Any suggestions for an
"easy" fix without going into VBA?
 
G

Golfinray

Access stores checkboxes as -1 for yes and 0 for no. You can easily convert
that by using an IIF statement. IIF([yourfield]=-1,"yes","no")
 
K

Klatuu

A checkbox is normally used as a control for a boolean (yes/no) field.
Boolean values are always either 0 or -1 and that is the way they are stored
in the table field. If you need to present something different to the user,
you can format the control where it is presented.
 
Top