Want 0 to show at beginning of my #

[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!

 

[Guest]

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

 

[dlel]

I've tried that and it didn't work. Do you have any other
ideas? Thanks!

 

[John Vinson]

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!

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.

 

[test]

-----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.


.