[Webinar] Streamline your web hosting managementRegister Today

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

How display number as 4 digits

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
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
open the table in design view
select the field
in the Format property place  0000
0
 
Ron MalmsteadInformation Services ManagerCommented:
Try setting the input mask to: 0000
The value however will still be 1
0
 
SteveL13Author Commented:
Thanks.  Part 2 of this issue in another topic named "How format 4 digit number in a combined text field?"
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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