Feedback by UserVoice

Tom Chambers

My feedback

  1. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Tom 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.

Feedback and Knowledge Base