ADO Checkbox Defaults for New Dirty Record

R

rogge

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
 
R

rogge

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top