Conditional Formatting

[Guest]

How do I format a field in a table to change colors when I enter "Yes" I want
the field to turn Green and when I enter "No" I want the field to turn Red.
When I apply conditional formatting through design view form and put text in
the form text box nothing happens. Not sure how to set formula up for "Yes"
or "No" request.

 

[p]

You wont be able to view conditional formatting within a datasheet
view.

Put the table on a form and then set its view to "Continuous forms" ~
Then you'll reveal your conditional formatting

now someone go answer my question!!!

 

[Guest]

Is the underlying field a text data type? If so, open your form in design
view. Select the text box in question. Click on Format > Conditional
Formatting...

Enter:
Condition 1
Field Value Is Equal to "Yes"

Condition 2
Field Value Is Equal to "No"

Select the appropriate font/fore color for each condition. Note: Use
quotation marks around the appropriate choices, as indicated above.


Tom Wickerath
Microsoft Access MVP

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

 

[Ron2006]

And by the way,

Conditional formating DOES work on Datasheet view.

Ron