expression changing text color in a text box

[Jacqueline]

I have created a reprot for the college that lists all room assignments with
data that our scheduling assistants will need. I would like to change the
text color of the course title to RED if the class text is = Like "CANC*"

Is this possible. (I am using 2007)
Thanks

 

[Evi]

Use conditional formatting. (on the Format menu, even in that peculiar 2007
version, I believe)
Evi

 

[Jacqueline]

Yes, I found that, and was able to set the word to red but do you know how to
use the expression? Some the assistants do not input CANCELLED come will use
CANC or Cancel. I wanted the conditional formating to see a wild card

"CANC*" but it does not work...

 

[John Spencer]

To do that with conditional formatting you will have to change the first
drop down to "Expression is" from "Field Value is" and then enter

[Name of Your Field] Like "Canc*"

With all the other ways to compare a field value, I'm surprised that MS
didn't include Like as an operator.

As an alternative I guess you could try
Field Value is Between Cancaaaa and Canczzzz
which should work

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Evi]

Under where it says Condition 1, choose Expression Is

and in the next box type

[Your fieldName] Like "Canc*"
Evi

Note that this sort of formatting will work fine in a report but not in a
Datasheet form.
Evi

 

[Jacqueline]

OK, now I know what I was doing wrong, I was not including the the field nam.
Thanks so much...
--
Jacqueline

To do that with conditional formatting you will have to change the first
drop down to "Expression is" from "Field Value is" and then enter

[Name of Your Field] Like "Canc*"

With all the other ways to compare a field value, I'm surprised that MS
didn't include Like as an operator.

As an alternative I guess you could try
Field Value is Between Cancaaaa and Canczzzz
which should work

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Yes, I found that, and was able to set the word to red but do you know how to
use the expression? Some the assistants do not input CANCELLED come will use
CANC or Cancel. I wanted the conditional formating to see a wild card

"CANC*" but it does not work...