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.
Asked
Active
Viewed 133 times
1 Answers
0
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.
Gustav
- 53,498
- 7
- 29
- 55
-
1Thanks. That coincides with everything I've researched as well. Too bad about this inconsistency between SQL and Access. – WhiteBearMike Dec 04 '19 at 18:34
-
1I strong suggest you don't allow or use null bits with Access. Always have the bit field default to 0. – Albert D. Kallal Dec 05 '19 at 22:00