By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,158 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,158 IT Pros & Developers. It's quick & easy.

Coloured box in report when matching a certain string or character

P: n/a
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
Aug 15 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <x@x.xwrote 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

Aug 15 '06 #2

P: n/a
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
Aug 15 '06 #3

P: n/a
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
Aug 15 '06 #4

P: n/a
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

Aug 15 '06 #5

P: n/a
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" <x@x.xwrote 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

Aug 15 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.