microsoft and sql2000 - what datatype to use for the checkbox field in access

  • Thread starter Thread starter TracyG
  • Start date Start date
T

TracyG

using sql 2000 database table, what data type should be used to correctly to
handle a checkbox field in a form. Access seems to expect 0 and -1 to
interpret the values for the checkbox, but the results when querying the
field values seem inconsistent. I had used a character varchar field.
 
It is a Boolean Field in Access and the equivalent is the "Bit" Field in SQL
server. I also set Null not allowed in the "Bit" Field.

You will have to be careful in Access as the 2 possible values in Boolean
Field are -1 (True) and 0 (False) while the 2 values in MS-SQL are 1 (True)
and 0 (False).
 
Back
Top