Regarding the Number Field

[cnuhima]

Hi guys,

In the ZipCode text box ,The default value is 0.But when i type the zipcode as the 02921..Its deleting the starting 0 and just saving as 2921..
How can I save the zipcode which includes 0..

Please help me out..


With Regards,
HimaBindu.B

 

[pbaldy]

Zip codes should be stored as text rather than numbers, in part because of the leading zero problem (a numeric field will not store leading zeros).

 

[cnuhima]

Thank You very Much...

 

[missinglinq]

In point of fact, any field that contains all digits (ZipCodes, ID numbers, Account numbers, etc.) should be defined as Text. Only fields that will be used (or potentially could be used) in mathematical calculations should be defined as Numbers.