Want 0 to show at beginning of my #

  • Thread starter Thread starter dlel
  • Start date Start date
D

dlel

How can I get a zero to show at the beginning of numbers
that are input into a field, i.e., 030504? Thanks in
advance!
 
Try changing the 'Input Mask' to something like 0000 (or
however many digits will be in your number). If the number
could be 5 or 6 digits long, for example, try 000009
 
How can I get a zero to show at the beginning of numbers
that are input into a field, i.e., 030504? Thanks in
advance!
Click to expand...

Two suggestions:

- If these are identifiers rather than numbers with which you will be
doing arithmatic calculations, use a Text field rather than Number;
set its Input Mask property to

000000

to force entry of six numeric characters.

- If you will be doing math with the values, set the field's Format
property to (again) 000000. This will not STORE leading zeros (the
number is stored as a binary computer word) but it will display them.
 
-----Original Message-----


Two suggestions:

- If these are identifiers rather than numbers with which you will be
doing arithmatic calculations, use a Text field rather than Number;
set its Input Mask property to

000000

to force entry of six numeric characters.

- If you will be doing math with the values, set the field's Format
property to (again) 000000. This will not STORE leading zeros (the
number is stored as a binary computer word) but it will display them.


.
Click to expand...
 
Back
Top