• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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
0
smods
Asked:
smods
  • 3
1 Solution
 
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
 
Rey Obrero (Capricorn1)Commented:
in the design view of the report, select text1, then
Format > conditional formatting, and set as shown

 x
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now