Computer and Software Support


Using wildcard characters in validation rules 

Microsoft Access

You can use wildcard characters in your validation rules. 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.

By default, all .accdb and .mdb files use the ANSI-89 standard.

You can change the ANSI standard for a database to ANSI-92 by using the following procedure:

  1. On the File tab, click Options.

  2. In the Access Options dialog box, click Object Designers.

  3. In the Query design section, under SQL Server Compatible Syntax (ANSI-92), select This database.

For more information about using wildcard characters and the ANSI standards for SQL, see the article Access wildcard character reference.

 

Go Back

OR

First Page

You can also

Return to Validation Rule