Results 1 to 2 of 2
  1. #1
    spradhan is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    1

    Smile about number field in table


    I am trying to enter data in number field like this 01234 but it
    did not show zero(0) how can i solve this problem.I mean i want
    to put zero(0) in begin of data in number field.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    A numeric data type will not store the leading zeros. You can present it to the user with the Format() function to pad the zeros:

    Format(FieldName, "00000")
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Field displays number instead of value
    By rdueck in forum Reports
    Replies: 6
    Last Post: 02-25-2010, 08:19 PM
  2. How to Increment A Number Field
    By Advanced in forum Programming
    Replies: 3
    Last Post: 01-27-2010, 02:36 PM
  3. Field switching from Number format to Text
    By COforlife in forum Queries
    Replies: 1
    Last Post: 11-10-2009, 03:23 PM
  4. Report the number of occurrences in a field
    By ecpike in forum Reports
    Replies: 1
    Last Post: 05-05-2009, 01:57 PM
  5. Replies: 1
    Last Post: 02-05-2009, 04:53 PM

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