Keep in mind that Access supports two sets of wildcard characters: ANSI-89 and ANSI-92.
Each of those standards uses a different set of wildcard characters.
This article explains how to use validation rules and validation text in table fields and form controls.
A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.
You can use an expression to perform calculations, manipulate characters, or test data. For example, an expression can check for one of a series of values, such as "Tokyo" Or "Moscow" Or "Paris" Or "Helsinki".