Wild card searches

Wild cards in a search are characters that will match any character in the field. You can use them where you're trying to find something like 'a code that starts with 'S' and includes an 'x''.

Wild cards

Access supports two wild card characters:

? matches any single character.

* matches any number of characters - including none.

Just type these characters as part of the expression you're searching for.

Examples

a?e Matches 'are', 'database', 'A/e',
8?7 Matches '1817', '8a7', and 'B48 7PQ' - remember that a space counts as a character.
a*e Matches 'Alvechurch', 'database', and 'Mary had a little lamb' because * matches any number of characters - including one.
8*7 Matches 'SER#83/3471a', '1817', and '87' because * matches any number of characters - including none.

More tips from Alvechurch Data

More tips from Alvechurch Data

Search page for Alvechurch Data

Searching a web site with JavaScript.

Read More

FoxPro regular expressions

Using wild cards in the FoxPro Find dialog.

Read More

Access search options

How to set the default search options in a Microsoft Access database.

Read More