I have an Access table with a boolean column and where the default value is 0 (zero).

In the IDE, that column is defined as a bit type and given a default value of 'False'. The Checked and Unchecked values default to 1 and 0 respectively, and when you try to move away from the column to another column in the IDE, it triggers a validation error. Suggest you change this behavior so that the default value matches the Unchecked value for a bit, so that the user doesn't become confused. I have always used 1 and 0 to default an Access Yes/No value, so if we need to change this to 'True/False' to work with Access in Plum, then it should be documented.

Jeff

--
_______________________________

Jeff Fleitz
Tekquest, Ltd
Integrated Digital Solutions
http://www.tekquest.com
866.472.5868
_______________________________


Reply via email to