Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How display number as 4 digits

Posted on 2013-05-31
3
Medium Priority
?
352 Views
Last Modified: 2013-05-31
If I enter a value of 0001 in a number field in a table, I want it to format exactly as that. "0001", not "1".

How?

I have the field setup as general number, 0 decimals.
0
Comment
Question by:SteveL13
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39211523
open the table in design view
select the field
in the Format property place  0000
0
 
LVL 25

Expert Comment

by:Ron Malmstead
ID: 39211528
Try setting the input mask to: 0000
The value however will still be 1
0
 

Author Closing Comment

by:SteveL13
ID: 39211617
Thanks.  Part 2 of this issue in another topic named "How format 4 digit number in a combined text field?"
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

972 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