After linking, only -1 or 0, not null

[aspfun]

I used Access to link to a table in SQL server.
After linking, a bit data type in SQL server became "yes/no" column in Access but only list "-1" or "0", missing "null".
How to list "null" in Access linked table?

 

[llkhoutx]

Null is nothing, neither yes, nor no. If nothing is specified in a record for the field, you get a Null, unless the SQL SERVER side forces a 0 for Null which I doubt.

I always test for True or Not True, Null kills you sometimes becuase it's not No.

 

[boblarson]

I just tested and, it's true that you can set a bit in SQL server to accept nulls, but you can't have it null in Access when linked to SQL Server.