field formating...

J

JayL

All -
I have a field in a table that is numeric. It should be 11 characters but
the table is omitting the leading zero's.
Ex: 00092557589 is showing as 92557589. The problem is I need the leading
zero's.
Any ideas?
 
J

John Vinson

All -
I have a field in a table that is numeric. It should be 11 characters but
the table is omitting the leading zero's.
Ex: 00092557589 is showing as 92557589. The problem is I need the leading
zero's.
Any ideas?
Click to expand...

If this is an identifier field (like a serial number or part number)
and will not be used for calculations, I'd just use a Text datatype.
Long Integer numbers are limited to two billion odd - ten digits - in
any case; and as numbers, the two you posted are exactly the same
number.

Set the text field's Input Mask to "00000000000" to enforce entry of
eleven digits.

John W. Vinson[MVP]
 
Top