Results 1 to 6 of 6
  1. #1
    Alliana Gray is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    22

    Why does my percentage field automatically display 0.00%

    I have a table with one field with data type number, field size decimal, and format percent. I enter a number I want like 3.47 and it stores it fine without rounding or anything. However I'm very perplexed why it automatically displays 0.00% first before you enter anything, and if you decide to leave the form blank it displays 0.00% instead of a null value.

    Is there any way to fix this?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,973
    Hi

    When you create a number field access sets its default value to 0(Zero).
    If you remove this it will display new records a null.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Alliana Gray is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    22
    But with every other number field in my table, the record remains null until you enter a number for the record. The only exception is the percentage field.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,973
    Have you removed the "0" from the "Default Value" property for this field?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Alliana Gray is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    22
    Ah, that's the problem. Thanks so much!

  6. #6
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,973
    You're welcome
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Field automatically filled
    By Douglasrac in forum Forms
    Replies: 3
    Last Post: 02-15-2011, 11:33 AM
  2. Replies: 5
    Last Post: 12-17-2010, 11:06 AM
  3. Replies: 2
    Last Post: 09-20-2010, 09:02 PM
  4. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM
  5. Replies: 4
    Last Post: 01-19-2010, 05:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums