We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


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

Medium Priority
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?
Watch Question

Database Architect / Application Developer
Top Expert 2007
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

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?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

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.


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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.