An error occurred while saving the commentTom Chambers commented
I agree with kb9zzo. Please add an Access or database level option to turn the default off for all number fields, including currency.
There is a big difference between knowing a value exists and stating that it is zero. The null value addresses this very nicely. Also, as kb9zzo mentioned, fields that are included in a unique index with "ignore nulls" turned on choke on the zero default.
I ask that you include the currency field with this option. I use the currency field to capture 64 bit hash code values -- the currency field is backwards compatible with earlier versions of Access, whereas the big integer / large number field is not. I index the currency field when I use it with hash codes.
If you have a lot of numeric fields in a table, it tedious to have to go through all of them and remove the default.
Thank you for considering this request.