How do you print leading zeroes in a zip code

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You need to use a calculated field in the query that is the source for the
labels:

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