I have same problem in 2005 & 2008. MS Access 2003 DB, windows Vista OS.

I created a DB in Access. I added the DB, selected details and dragged it onto the form where it created the the table adapter, bindingsource and binding navigator. Everything works great except when I click the "add" button on the binding navigator all the checkboxes get filled with a solid square (which I assume is the indeterminate state). The data type for the checkboxes in the DB is set to Yes/no, format is true/false, I even added a default value of false and a validation rule to "true or false". I assume this prevents a null state in access but not sure. I even tried a checkbox1.checked=false in the add button click event. Nothing I tried works as I want all the boxes to be unchecked when I when I click the "add button". Also the Threestate property for the checkboxes is set to false. Anyone got a clue??? cuz i'm baffled.

Hi there.. Before anything, any "rule" that you add to the database stays inside the database (is not replicated to anywhere). Said that, I don't have a clue about why you see the checkboxes in that state.. Could be a settings problems? (like for example the color of the checkbox?)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

its strange. It only does it with the add button. I can view all the records I added when the form loads, all the checked boxes look right and all the unchecked boxes look right, like there was never a problem, its only when I click the add button do all the boxes show a solid blue square.