Does your organization have rules for entering certain data, such as account numbers, employee numbers, part numbers, or invoice numbers? Rather than re-creating an input mask for every Access form in which to enter the data, you can create it once in the field's property box in one form, and it will be available to any other form.
For example, say you want to create an input mask for entering employee IDs. To do so, follow these steps.
- Open the Employee Data form.
- Double-click the Employee ID field.
- Under the Data tab, right-click the Input Mask field property.
- Click Build.
- Click Edit List.
- Click the New button.
Miss a tip?
Check out the Microsoft Access archive, and catch up on our most recent Access tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.