Input Masks and Zip Code Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Che - 29 Mar 2006 22:02 GMT

I imported a table from excel and now the zip code column will not show a "0"
in front of certain postal codes (i.e. the zip code for 02116, shows 2116).
How do I use the input mask to properly set the zip code format?

Reply to this Message

Douglas J Steele - 29 Mar 2006 22:28 GMT

When you imported, Access must have set the field to numeric.

Add a new Zipcode field to your table, and make it Text.

Use an update query to update the new field to Right$("00000" & OldZipField,
5)

Once you've checked that the new field is correct, you can delete the old
field.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I imported a table from excel and now the zip code column will not show a "0"
> in front of certain postal codes (i.e. the zip code for 02116, shows 2116).
> How do I use the input mask to properly set the zip code format?

Reply to this Message