Create a new input mask for all your Access databases

Set up a template and save yourself from creating an input mask every time you want to enter new data. Here's how to create a new mask for each of your Access databases.

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.

  1. Open the Employee Data form.
  2. Double-click the Employee ID field.
  3. Under the Data tab, right-click the Input Mask field property.
  4. Click Build.
  5. Click Edit List.
  6. 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.

Editor's Picks

Free Newsletters, In your Inbox