numeric field that accepts leading zeros

L

Lori

I have a field in my form called TIN_Nbr that I have set as numeric with a
fixed format. This field stores a 9 digit number but I need it to store
leading zeros, which it keeps truncating the zeros. How can I fix this? Is
it at the table level or form level? Do I need to set the type to Text or is
there a number format I need to use?

Thanks!
 
F

fredg

I have a field in my form called TIN_Nbr that I have set as numeric with a
fixed format. This field stores a 9 digit number but I need it to store
leading zeros, which it keeps truncating the zeros. How can I fix this? Is
it at the table level or form level? Do I need to set the type to Text or is
there a number format I need to use?

Thanks!
Click to expand...

A number datatype field does not store leading zeros.
If you want to keep the field as Number, you can format the field as
000000000
and it will display leading zeros (but the zeros will not be stored).
If the field is not going to be used for calculations, why not simply
make the field's datatype Text.
 
Top