Coloured box in report when matching a certain string or character

[Julian]

I would like some of the fields of a coulmn of one of my report to turn into
light red when the field matches a certain string.
Julian

[Allen Browne]

Use Conditional Formatting.

In report design view, select the text box that should change color.
Choose Conditional Formatting on the Format menu.
Set upt the condition and colors you want.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Julian" <[e-mail] in message news:4k************@individual.net...

>I would like some of the fields of a coulmn of one of my report to turn
into
light red when the field matches a certain string.
Julian

[Julian]

I was trying few expressions, but nothing happens. Do I have to use any
brackets or other special signs to make them work? How can I add more than
three conditions?
Julian

[Julian]

To be more specific I would like to change the field colour when the
following messages are met: Not Responding, Left Voicemail message, Left
Text Message. Can I use wild cards? For example to use the word Left plus
anything that comes after?
Julian

[micha]

yes, you can use Wildcards.

for all Words containing "foo" you can use a Steing like this:

[Expression is] Forms!frmKeepOpen!txtTest Like "*foo*"
greets Michael

[Allen Browne]

You cannot have more than 3 conditions with conditional formatting.

You can use wildcards if you choose Expression in the first box, and use the
Like operator, e.g.:
[MyField] ... Like "Z*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Julian" <[e-mail] in message news:4k************@individual.net...

>I was trying few expressions, but nothing happens. Do I have to use any
brackets or other special signs to make them work? How can I add more than
three conditions?
Julian