=========
EXAMPLES
———
Phone Number:
If numbers stored as text:
Format([field],"@-@@@-@@@-@@@@")

If numbers stored as numbers:
Format(2127851212,"(000)000-0000")

———
Format([Store],"0000")

Input Mask for Table Field:
!(999)000-0000

———
ZIP: IIf(Len([ZipCode])<6, Format([ZipCode],"@@@@@"),Format([ZipCode],"@@@@@-@@@@"))

 


http://www.anysitesupport.com/access-format-fields/