Access VBA Macro Programming

You can also use wildcard characters. A?denotes a single character and a*denotes a

string of characters. It is exactly the same as doing a file search when you use wildcard

characters. A table of pattern characters is shown here:

Character Meaning

? Any single character

* Zero or more characters

# Any single digit (0–9)

[charlist] Any single character incharlist

[!charlist] Any single character not incharlist

The following examples will return True:

MsgBox "RICHARD" Like "ri?hard"

MsgBox "RICHARD" Like "ric*"

80 Microsoft Access 2010 VBA Macro Programming