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

[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

 

[theDBguy]

Phones always do

" " " "

Just checking... Didn't happen before, and doesn't seem to be happening now... Curious...

Sent from phone...

 

[access2010]

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.

Thank you TheDBguy for your suggestion, which we did try, but receive the following error message.

 

[access2010]

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

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

Thank you June7 for your suggestion, which we did try, but receive the following error message.

 

[Ken Sheridan]

If the complete contents of the control are enclosed in parentheses, as in your posted examples, try the following expression:

Left([FullName],1)="(" And Right([FullName],1)=")"

 

[June7]

Your attempt does not do what I suggested. Expression is: InStr([Advice], "(") > 0

 

[access2010]

suggested on post #2

Thank you! Arnelgp, for your file, which works.

[Advice] Like "*(*)*" works. My problem was that I was using the wrong brackets, as June7 pointed out.

I do appreciate your assistance. Frida

 

[access2010]

If the complete contents of the control are enclosed in parentheses, as in your posted examples, try the following expression:

Left([FullName],1)="(" And Right([FullName],1)=")"

Thank you Ken for your suggestion.

My problem as pointed out by June7, was that I was using the wrong brackets.

 

[access2010]

Your attempt does not do what I suggested. Expression is: InStr([Advice], "(") > 0

Thank you for your suggestion, I have found Arnelgp suggestion of [Advice] Like "*(*)*" works.

 

[Ken Sheridan]

Expression is: InStr([Advice], "(") > 0

That will return True if the string expression contains a leading parenthesis anywhere in the string, so assumes this will be matched by a closing parenthesis. If the Instr function is to be used, a more robust expression, which will only return True if there are correctly positioned opening and closing parentheses would be:

Instr(FullName,"(")>0 And InstrRev(FullName,")")>Instr(FullName,"(")

Pattern matching with the Like operator is a better solution, however, as the OP has now realised.