Number field not showing two digits when it is a single digit.

Posted on 2011-04-28
Last Modified: 2012-05-11
In my table I have a field that is a number data type.  If the number
is a single digit I need it to start with a 0 (zero), like if it is a 7, I need it to display 07 in my table.  I am having a problem
getting the 0 (zero) to stay even when I manually add it. Is there a way to
fix this?
Question by:donnie91910
    LVL 75

    Accepted Solution

    Put 00 as the Format for that field in the table design ... see image

    LVL 1

    Expert Comment

    I have found that in order to get a 0 you will need to save it as a text field. is there a reason it has to be a numeric field?
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    I can be Numeric and easy Formatted for display, in a number of ways ... including the way I showed.  No need really to change to text.

    LVL 44

    Expert Comment

    A table design allows the odd perk - one being to prepend zeros to a number and still be able to datatype it as a number.   However, when you use that field in a query, the preceding zeros disappear.  I believe the field Format will carry over to a Form or a Report.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now