Use an Input Mask to control data entry in an Access database. For example, you can force users to enters a phone number with an area code or an employee identification code with 2 letters followed by 3 numbers.
Below is a cheat sheet for Access input masks.
(000)-000-0000 will force the user to enter a phone number with an area code.
(999)000-0000! will force to user to enter a 7 digit phone number but is optional for the area code. The exclamation mark causes the input mask read the numbers from left to right.
LL-000 will force the user to enter 2 letters followed by 3 numbers.
>L<??????????????? will make the first letter capitalized and the following letters lower case.
Check out my Access keyboard shortcuts guide or other Access blog posts by clicking on the Access link on the right sidebar.