Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2011
    Posts
    6

    Unanswered: Number fields defaulting to zero

    I have two number fields (one for zip code and one for employee ID#) that for some reason automatically appear with a "0" until info is recorded. How do I get the field to remain blank/empty until populated?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    My guess is that either the field in the table or the control on the form has a default value property that's putting the zero in.
    Paul

  3. #3
    Join Date
    Oct 2011
    Posts
    6
    Nevermind - i found it. thank you. it was the table.

    How and where do I check for this?

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help.
    Paul

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Zero is usually the Default for a Field of Number Datatype.

    Many developers, however, would use a Text Datatype for something like a Zip Code, not a Number Datatype. Fields that contain all digits are not necessarily Numeric. The usual litmus test is whether or not the Field will be used for mathematical operations. If the answer is 'Yes,' it's a Number; if 'No,' it's Text.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •