 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008expression changing text color in a text box
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  SignatureJacqueline Use conditional formatting. (on the Format menu, even in that peculiar 2007 version, I believe) Evi > 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 [quoted text clipped - 4 lines] > -- > 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... :( SignatureJacqueline > Use conditional formatting. (on the Format menu, even in that peculiar 2007 > version, I believe) [quoted text clipped - 8 lines] > > -- > > 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... :( OK, now I know what I was doing wrong, I was not including the the field nam. Thanks so much... SignatureJacqueline > 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 [quoted text clipped - 20 lines] > > > > "CANC*" but it does not work... :( 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 > 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 [quoted text clipped - 16 lines] > > > -- > > > Jacqueline |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.