To ensure that users enter data in a particular format, use the Input Mask property. Rather than typing the mask format yourself, Access has a wizard that offers samples of the most common data formats.
To use the Input Mask Wizard:
If you designate both an input mask and a format for a field, the format takes precedence when displaying the data, but the input mask controls how the data is entered. |