How do you print leading zeroes in a zip code

G

Guest

How can you format a label to print a full 5 digit zip code with a leading
zero. I currently link to an excell spreadsheet for this data and it is
formated there with the access special zip code format and shows correctly in
excell. It appears correctly in the access query, but I loose that leading
zero when I view the label report.
 
K

Ken Snell [MVP]

You need to use a calculated field in the query that is the source for the
labels:

LeadingZip: Format([ZipCodeField], "00000")
 

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

Leading zero from Zip Code not print on Label Merge 6
Printing Leading Zeroes in Excel 1
How can I get a leading zero (ZIP code) to show in a LEFT() calc? 2
How to merge Excel address columns when some zips begin with zeros 4
losing the leading zero when merging zip+4 postal code 1
Format>Cells>Special>Zip Code 5
Keeping Leading Zeros; How Please ? 2
How can you format cells in a column to display a 50 digit binary 3

Top