Solved

Conditional Formatting based on another fields value in a report?

Posted on 2011-02-26
5
233 Views
Last Modified: 2012-05-11
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
Comment
Question by:smods
  • 3
5 Comments
 
LVL 6

Expert Comment

by:AkAlan
ID: 34989466
Have you tried using the built in Conditional Formatting feature of Access?
Which version of acces are you using?
0
 

Author Comment

by:smods
ID: 34989486
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
 
LVL 6

Expert Comment

by:AkAlan
ID: 34989493
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
 
LVL 6

Expert Comment

by:AkAlan
ID: 34989518
I'm going to leave work soon so if you need an example let me know.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34989563
in the design view of the report, select text1, then
Format > conditional formatting, and set as shown

 x
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question