check box value

[iccsi]

It seems that the check box value is -1 when it is checked.
Is it possible to have set value as one?

Your information is great appreciated,

 

[Microsoft]

why would you want to do that?

 

[AkAlan via AccessMonster.com]

Access stores boolean as -1. if you need to referto it as 1, like when adding
in reports, use the abs (absolute value) function. So in the controlsource
you would put =abs(bitfield). Then it will return 1 instead of -1. Hope this
helps.