Input Masks and Zip Code Formatting

G

Guest

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?
 
D

Douglas J Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Input Masks? 1
input mask for phone number 2
Input Masks 1
Zip Code formatting problem 3
Zip Codes Dropping Leading Zero 3
Match 2 different zip code lists 1
Zip Code Formatting 9
format cells as zip code not working 3

Top