Search code examples
sqlms-accessnullzero

SQL Table Linked to Access Displays 0 instead of NULL

If I link an SQL table with a bit field that has NULL values and open up the linked table in Access, the NULL values are showing up as 0. I do want the NULL values to show NULL or blank in Access when opening up the table. I am not sure if this has some recent problem with a Microsoft update but it makes a difference because sometimes we are working on the table directly in Access and want to see if the field value is NULL without doing a search. Thanks.

Solution

  • I do want the NULL values to show NULL or blank in Access

    Maybe. However, this is a known limitation, and it won't happen - except if you change the data type to Integer.