Nine-digit zip codes

[Val Kurkas]

I'm sure someone has already answered this one before, but I have to ask
again! We have zip-code fields for which we're using an input mask that
does not store the hypen between the zip+four. In a report, we have
concatenated our [City]&", "&[State]&" "&[Zip] fields, but of course the
nine digit zips come out looking like 555554444 (without the hypen).

Using the Format function for the zip only sticks in the hypen whether or
not it is a five or nine digit. I think that I need to evaluate whether the
string is five or nine and use an IIF to apply the format function if the
zip is nine digit, but how? OR is there an easier way?

Seems like it should be so simple!

Thanks in advance for ANY help!

Val

[Gary Meyer]

You're on the right track. Look at article Q163604 in the MS knowledgebase.