Access: Format fields

=========
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/

By | 2011-04-12T09:45:43+00:00 April 12th, 2011|Access, Computers, Documentation, Microsoft|0 Comments