Results 1 to 3 of 3
  1. #1
    apetriella is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2015
    Posts
    7

    Issues with leading zeros in a form field

    I am having trouble keeping leading zeros in a form field. Access 2007 automatically truncates the zeros. How do I resolve this issue?

  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,518
    This is marked as solved; is it? If so, posting your solution could help others in the future. If not, it's probably a numeric field, which will not hold leading zeros. You can format it for user viewing with the Format() function.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    apetriella is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2015
    Posts
    7
    Quote Originally Posted by pbaldy View Post
    This is marked as solved; is it? If so, posting your solution could help others in the future. If not, it's probably a numeric field, which will not hold leading zeros. You can format it for user viewing with the Format() function.
    That's exactly it. All I had to do was go to the appropriate table and go to design view and change it from a number box to a text box. Problem solved.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-26-2015, 03:53 AM
  2. Trying to get leading zeros to show
    By Pegasus_Angel in forum Access
    Replies: 3
    Last Post: 10-25-2012, 11:40 AM
  3. Replies: 1
    Last Post: 07-11-2012, 07:16 PM
  4. Leading Zeros
    By dirtbiker1824 in forum Access
    Replies: 1
    Last Post: 03-14-2011, 02:16 PM
  5. Adding Leading Zeros
    By jo15765 in forum Access
    Replies: 13
    Last Post: 11-20-2010, 11:11 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