Zip Code + 4

[cjany]

I have zip code field which includes the + 4 digits. The field looks like 999999999

How can I format this field to look like this:

99999-9999

 

[PHV]

Use an input mask and a display format.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cjany]

Let me be more specific. This would be in an Access 2000 query or if it can be done in the report that would be fine too.

 

[PHV]

This would be in an Access 2000 query
myZipCode: Format([ZipCode field], "00000-0000")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886