Using Data Validation Answers

3 verified answers1 views

In the input mask format (999) 000-0000, what do the 9s represent?

required numbers

optional numbers

any number or letter

any number, letter, or symbol

What steps will create a validation rule error message? Use the drop-down menus to explain.

Answers:

1. Open the table in view.:Design

3. On the Field Properties General tab, in the box, type the message.:Validation Text

FormatInput Mask ✔ Validation TextValidation Rule

Format

Input Mask

✔ Validation Text

Validation Rule

Did you find these answers helpful?

More from this Course