Format Zip Code on report

[Guest]

Hello -
I have a report with a concantnated text box - City, ST Zip. When I set up
the table I used the zip code input mask. I'm trying to remove the trailing
dash from those zip codes that only have 5 digits, but want to keep the dash
for those zips we have the +4 digits for.
Thank you for any help

 

[fredg]

Hello -
I have a report with a concantnated text box - City, ST Zip. When I set up
the table I used the zip code input mask. I'm trying to remove the trailing
dash from those zip codes that only have 5 digits, but want to keep the dash
for those zips we have the +4 digits for.
Thank you for any help

Use an Unbound text control.
Set it's congtrol source to:
=[City] & ", " & [State] & " " & IIf(Len([Zip])>6,[Zip],Left([Zip],5))

 

[Guest]

THANK YOU It worked like a charm.

Hello -
I have a report with a concantnated text box - City, ST Zip. When I set up
the table I used the zip code input mask. I'm trying to remove the trailing
dash from those zip codes that only have 5 digits, but want to keep the dash
for those zips we have the +4 digits for.
Thank you for any help

Use an Unbound text control.
Set it's congtrol source to:
=[City] & ", " & [State] & " " & IIf(Len([Zip])>6,[Zip],Left([Zip],5))