Conditional Formatting based on another fields value in a report?

Hi all,

How would I say if the field "type" is equal to positive then the back colour of the text field "text1" is green and if the "type" field is equal to negative then the text field "text1" should have a back colour of red and a font colour of white?

Thanks

Chris
smodsAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
in the design view of the report, select text1, then
Format > conditional formatting, and set as shown

 x
0
 
AkAlanCommented:
Have you tried using the built in Conditional Formatting feature of Access?
Which version of acces are you using?
0
 
smodsAuthor Commented:
2003.  I am using that on other fields but there doesn't seem to be the option to base the formatting on a different field??
0
 
AkAlanCommented:
You need to use an expression when you go into Conditional Formatting the drop down "Field Value Is " select "Expression Is" then use the wizard. It will help a lot.
0
 
AkAlanCommented:
I'm going to leave work soon so if you need an example let me know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.