cant addnew to dataset when form has a checkbox

[Guest]

my data is an access mdb. the table has several columns of strings, booleans, dates, etc. i noticed that when i include a bound checkbox to a boolean (yes/no) column to my form that i cant add a new row to the table. but when i remove the checkbox and replace it with a text box that the problem goes away. the textbox shows true/false which is fine. but the user would have to type in true or false which is not practical. i assume that there is a property for the checkbox that i need to correct but i dont know which one. any advice? thanks in advance.

 

[Matt Berther]

Hello sny,

The checkbox control has an issue with handling null values when being databound. See if this post helps you:
http://groups.google.com/groups?q=c...f=1&selm=OHkMju$iCHA.3736@tkmsftngp08&rnum=10

 

[William Ryan eMVP]

What property were you binding to? It should be checked.

my data is an access mdb. the table has several columns of strings,

booleans, dates, etc. i noticed that when i include a bound checkbox to a
boolean (yes/no) column to my form that i cant add a new row to the table.
but when i remove the checkbox and replace it with a text box that the
problem goes away. the textbox shows true/false which is fine. but the
user would have to type in true or false which is not practical. i assume
that there is a property for the checkbox that i need to correct but i dont
know which one. any advice? thanks in advance.

 

[Guest]

the column is bound to the checkbox's Checked propert

(i used the data form wizard to create this form)

 

[William Ryan eMVP]

Ok, then it's almost certainly the Null issue Matt referred to.

 

[Mika M]

Hi Sny!

These links may be useful ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;326440
http://support.microsoft.com/default.aspx?scid=kb;EN-US;321504

my data is an access mdb. the table has several columns of strings,

booleans, dates, etc. i noticed that when i include a bound checkbox to a
boolean (yes/no) column to my form that i cant add a new row to the table.
but when i remove the checkbox and replace it with a text box that the
problem goes away. the textbox shows true/false which is fine. but the
user would have to type in true or false which is not practical. i assume
that there is a property for the checkbox that i need to correct but i dont
know which one. any advice? thanks in advance.

 

[Guest]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;32150

thanks !!!!!!!!!!!!!!!! = this is the solution