Format zip codes

[eacollie]

I have a report bound to a query that includes zip codes as a field. Zip codes are formatted in the table as 99999-9999 and display in this format when the query is run. However, when I place that field in the report text box as

=[ContactCity] & ", " & [StateAbbreviation] & " " & [ContactZip]

or even as [ContactZip]

The zip is not formatted.

I'm sure it's something simple I'm doing incorrectly but can't seem to find it.

Thanks much

 

[pr2-eugin]

You could use Format again?

=[ContactCity] & ", " & [StateAbbreviation] & " " & Format([ContactZip], "#####-####")