Change the background colour to red if the (word) or (words) are surrounded by a Bracket (4 Viewers)

[access2010]

I can control the background colour for a single word in MsAccess 2003, but have not been able to find out how to control the background colour if the word or words are contained (within) Brackets..
I have tried

Operator: Expression Is
Condition: Like "*(*)*"(*)

This looks for any text within parentheses and produces an error.
Your assistance would be appreciated.

Thank you Frida

 

[theDBguy]

Are you looking for more than one set of brackets? Have you tried?

Like “*(*)*”

PS. Typing from phone, not sure why it created a smart quote. Make sure to type the above code into your project manually, don’t copy and paste.

 

[June7]

Parentheses are: ( )
Brackets are: [ ]
Braces are: { }

Maybe just look for opening parenthesis: InStr([Advice], "(") > 0

 

[arnelgp]

suggested on post #2

 

[CJ_London]

Typing from phone, not sure why it created a smart quote

Phones always do