String comparison with wildcard characters

[HVACMAN24]

How can i compare a string to check and see if it has an asterick in it? I know an asterick is a wildcard character for any number of characters, but I want to check and see if my string has one at the beginning of it then bold that particular string. The closest I got was bolding all my labels.

I've been through access help and done some other internet searches but I havent found the write answer yet. I sure someone here does.

Thanks

 

[Brianwarnock]

From access help

Wildcard Characters Used in String Comparisons


Built-in pattern matching provides a versatile tool for making string comparisons. The following table shows the wildcard characters you can use with the Like operator and the number of digits or strings they match.

Character(s) in pattern Matches in expression
? Any single character
* Zero or more characters
# Any single digit (09)
[charlist] Any single character in charlist
[!charlist] Any single character not in charlist



A group of one or more characters (charlist) enclosed in brackets ([ ]) can be used to match any single character in expression and can include almost any characters in the ANSI character set, including digits. In fact, the special characters opening bracket ([ ), question mark (?), number sign (#), and asterisk (*) can be used to match themselves directly only if enclosed in brackets. The closing bracket ( ]) can't be used within a group to match itself, but it can be used outside a group as an individual character.

 

[HVACMAN24]

Yea I went trough all that before posting on here but every combination i try doesnt work the way I want it to. I would think that from what the help says that,

if string like "
[*][a-z]"

would work but its not.

 

[vbaInet]

You could Conditional Format it:

Expression Is: Left([String], 1) = "*"

 

[Brianwarnock]

try

Like "[*]*"

Brian