ADO Checkbox Defaults for New Dirty Record

[Guest]

How do I default check boxes to False (un-ticked) with ADODB connection? and
other strange behaviour... thank you

the form has four (4) check boxes. When a user clicks the "New Record"
button (programmed for a good UI - goes to new record, disables some
navigation controls, etc...) and enters data into any control all the check
boxes become ticked.

I have tried
• setting the defaults on the table to -1, 0, and 1.
• setting the defaults on the check boxes to -1, 0, 1, and False
• toggleing "retrieve defults" for the form between "Yes" and "No"
• programatically setting the check boxes to un-ticked on the "On Dirty" Event

Other behavior:
Clicking the check boxes wth the mouse only ticks the boxes; one can't
un-tick the boxes. HOWEVER, pressing the space bar will tick/un-tick the
active control.

ADODB Connection
BE: MS SQL Server 2000 SP4 / WinServer 2003 SP(Latest)
FE: MS Access 2003 (XP) / Win XP SP2

Form: Unique table is set
Form: Resynch command is set
Check box: Triple state = no

 

[Guest]

changed data type from 'bit' to 'int' and this solved the problems. now to
verify queries that use the fields in where clauses.