Format Zip Code

[allredkj]

I have a table where the zipcode holds 9 characters. I would like to perform an update query to add any leading zeros to the first set of 5 characters and then produce output including a dash: 99999-9999.

I tried this, but getting "undefined function in expression" error:
Update to: Format([ZIP],"00000-0000")

I also tried this and same error:
Update To: Format([ZIP],"@@@@@-@@@@")

Can you assist?

 

[John Big Booty]

You can either set the formatting at table level by simply inserting 0000-0000

Our you can set it at Form level.

 

[Galaxiom]

You may have a references problem. Has the database been converted from another version?

BTW Format doesn't work like that unless the characters are all numeric.