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

[Guest]

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,

 

[Guest]

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

 

[Joseph Meehan]

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?

Postal codes are not number, they are characters. Don't use a number
field. Also remember that if you have any international addresses you are
going to need to have letters as well as numbers.