checkbox binding to bit column

[Rick in Savannah]

I have a bit column in an SQLSrvr table, and I'd like to bind a checkbox on
an Access form to it. What are the correct properties of the checkbox to
make this work? Thanks.

 

[Rick in Savannah]

You can't have NULLs in your bit column when you try to update it from an
Access MDB. Here's the TechNet writeup:

http://support.microsoft.com/default.aspx?scid=kb;en-us;280730