Mail Label Zip Code

[rgeoffb]

Trying to do address labels. Used the wizard to create, no problem. In the last line I used the following:

=Trim([City] & ", " & [State] & " " & [Zip]).

It works but there is a problem. The Zip Code shows as 123456789. There is no "-" between the 5th and 6th number. The records are stored with the "-" in the proper place. Not all of the records have the full 9 digit number stored, some are only 5 digit so the "-" is not necessary.

Thanks

 

[RichO]

It looks like your zip may be stored as a long number with an input mask of #####-####.

Try this, it will print 5 digit zip codes without a trailing dash and 9 digit zip codes with a dash.

=Trim$([City]) & ", " & Trim$([State]) & " " & Left([Zip],5) & IIf(Len([Zip])>5,"-" & Mid([Zip],6,4),"")