I am trying to build applications with the idea of moving the data to sql server. So for my boolean field I set it to be a number field - integer with 0 for decimals and 0 to be the default.
I want to use this in a checkbox on my access form. Is there any way to use a checkbox and have it specify that 0 will be unchecked and 1 will be the checked value?