printing zip code+4 on labels

[C. Mitchell]

Using the label wizard to create mailing labels in Access
97, I find that the zip code + 4 leaves out the hyphen
although the hyphen prints on other reports. Also the
space between the label rows does not match the Avery 5160
Labels. Is this a glitch in 97's wizard? Can anyone help
me with these two problems? Thank you.

 

[Duane Hookom]

Apparently your zip codes are saved without the hyphen. I always save the
mask values with the field value. What is the current expression used in the
control source of your label.

You can adjust the label heights by setting the detail section height to
your label height and don't allow it to grow.

 

[C. Mitchell]

The control source was =Trim([City] & ", " &
[StateOrProvince] & " " &[PostalCode]) but is now =Trim
([City] & ", " & [StateOrProvince] & " " & Format
([PostalCode],"00000-0000")) I changed it at the advice
of my son. Now I have a new problem. The zip code is
correct for those entered with 9 digits, but those for
which I had entered only 5 digits now begin with 4 zeroes,
which makes the zip code incorrect. The hyphen was
already showing up on the data sheet view and in all other
reports, just not on the labels for which I used the Label
Wizard. Thank you very much.

 

[Duane Hookom]

You can change your zip section to
Left(PostalCode,5) & IIf(Len(PostalCode)>5,"-" & Mid(PostalCode,6),"")

--
Duane Hookom
MS Access MVP

The control source was =Trim([City] & ", " &
[StateOrProvince] & " " &[PostalCode]) but is now =Trim
([City] & ", " & [StateOrProvince] & " " & Format
([PostalCode],"00000-0000")) I changed it at the advice
of my son. Now I have a new problem. The zip code is
correct for those entered with 9 digits, but those for
which I had entered only 5 digits now begin with 4 zeroes,
which makes the zip code incorrect. The hyphen was
already showing up on the data sheet view and in all other
reports, just not on the labels for which I used the Label
Wizard. Thank you very much.

-----Original Message-----
Apparently your zip codes are saved without the hyphen. I always save the
mask values with the field value. What is the current expression used in the
control source of your label.

You can adjust the label heights by setting the detail section height to
your label height and don't allow it to grow.

--
Duane Hookom
MS Access MVP





.