conditional formatting Text

[Guest]

i am stuck again, thanks to any one who can help me

i am trying to create a course timetable i want Session field to change
colour when either Lunch or coffee are displayed

i have tried conditional formatting and used

Field value is: equal to "Coffee"

this has worked when i use dates or numbers but i do not know how to use
text in conditional formatting

thanks for any help or giuddance

Philk

 

[Guest]

Hi Phil,

Try entering Coffee without the quotes in the conditional formatting dialog.

Here is an article that discusses conditional formatting:

Conditional Formatting
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

i am stuck again, thanks to any one who can help me

i am trying to create a course timetable i want Session field to change
colour when either Lunch or coffee are displayed

i have tried conditional formatting and used

Field value is: equal to "Coffee"

this has worked when i use dates or numbers but i do not know how to use
text in conditional formatting

thanks for any help or giuddance

Philk

 

[Guest]

Tom

thanks for your reply, when i came in this morning i realised i was using a
lookup field and it was after a number not text

thanks again

Phil

 

[Guest]

Hi Phil,

Those evil Lookups! Thanks for bringing this to my attention. If you
haven't already seen it, you might want to look at the 2nd commandment here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Tom

thanks for your reply, when i came in this morning i realised i was using a
lookup field and it was after a number not text

thanks again

Phil
__________________________________________

:

Hi Phil,

Try entering Coffee without the quotes in the conditional formatting dialog.

Here is an article that discusses conditional formatting:

Conditional Formatting
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

i am stuck again, thanks to any one who can help me

i am trying to create a course timetable i want Session field to change
colour when either Lunch or coffee are displayed

i have tried conditional formatting and used

Field value is: equal to "Coffee"

this has worked when i use dates or numbers but i do not know how to use
text in conditional formatting

thanks for any help or giuddance

Philk

 

[Guest]

Thanks for that Tom

could have done with those beofre i started this project. i have added
removing lookups to my list of things to sort out before this database is
finished.

Phil