Microsoft Office Tutorials and References
In Depth Information
Validate that data in a field is of the correct type
Add a field validation rule and default
1 Type a value or expression for Default Value. (Date() is today’s date.)
2 Type a rule to check that the data is valid.
3 Add a text message to help the user when invalid data is entered,
and save your design.
Description (examples are for first part of the
Digit (0 to 9, entry required, plus [+] and minus [–]
signs not allowed). Example: 000 enters a number
987; 98 would not be allowed.
Digit or space (entry not required, plus and minus
signs not allowed). Example: 999 would allow both
987 and 98 to be entered.
TIP The validation rule also includes a build button (…), which
can provide additional assistance in creating more complex
Digit or space (entry not required; spaces are
displayed as blanks in Edit mode, but blanks are
removed when data is saved; plus and minus signs
Letter (A to Z, entry required). Example: LLLL would
allow the code DUCK but not DOG.
Letter (A to Z, entry optional). Example: ???? would
allow both DOG and DUCK.
Letter or digit (entry required). Example: AAA would
allow the code 99A but not 99.
Letter or digit (entry optional). Example: aaa would
allow both 99A and 99.
Any character or a space (entry required). Example:
00&00 would allow 53/22 but not 53/2.
Any character or a space (entry optional). Example:
00C would allow 99B but not 9B.
Causes all characters to be converted to lowercase.
Example: <LLLL would save Duck as duck.
Causes all characters to be converted to uppercase.
Example: >LLLL would save duck as DUCK.