Solved

How display number as 4 digits

Posted on 2013-05-31
3
329 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 500 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

789 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