Zip Code Formatting

[Guest]

I am having a problem formatting my postal codes in Access 2003. Instead of
showing the "0", it omits it. How do I properly set up tables to format zip
code numbers?

 

[Guest]

Set the field type to Text and use an Input Mask.

 

[Rick B]

Set the field as a TEXT field, not a number field. Numbers are used if you
need to perform math on the field.

 

[Guest]

I tried using the input mask and used the zip code option, unfortunately, it
still will not show the "0" or, if I add a placeholder to the front, it will
show the "0" for places like FL and AZ. What did I input improperly?

 

[Guest]

I don;t think you can apply the zip format to a number field.

 

[Douglas J Steele]

Actually, you can. You just shouldn't.

 

[Guest]

I tried it as a text field and then input a mask, but I'm getting nothing.

 

[Guest]

I tested this input mask: 9999\-999;0;*

The zero was not cutoff...what input mask are you using and which zero is
cutoff?

 

[Joseph Meehan]

I am having a problem formatting my postal codes in Access 2003.
Instead of showing the "0", it omits it. How do I properly set up
tables to format zip code numbers?

I suggest that you don't use a zip-code mask, at least not unless you
are 100% sure that you will not have any non-US addresses. Just use a text
field.

 

[Joseph Meehan]

I am having a problem formatting my postal codes in Access 2003.
Instead of showing the "0", it omits it. How do I properly set up
tables to format zip code numbers?

BTW is that any zero or just a leading zero or a trailing zero?