How to create a default field for zipcode with a zero beginning

[Rural Land Trust]

We have many people within one town with a zip code beginning with zero. We
can put in the Town, the State abbrviation, but can only create a field to
accept the last 4 digits (non-zeroes) in the field we are using for a zip
code. Any ideas?

 

[George Nicholson]

Numbers simply don't have leading zeros. Change the field from Numeric to
Text.

Unless you are planning on doing math functions (addition, subtraction,
multiplication) with your zipcode field, you won't be losing anything.

HTH,

 

[Jackie L]

Make sure your zip code field is text in the table design instead of number.