Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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

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?
Thanks
0
donnie91910
Asked:
donnie91910
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Put 00 as the Format for that field in the table design ... see image

mx
Capture1.gif
0
 
mona4980Commented:
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?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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.

mx
0
 
GRayLCommented:
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.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now