Conditional Formating In A Report

[cadsvc]

My report includes more than 2 fields, but my question is with 2 fields; [Operator] and [Parameter]



[Operator] data is either an "X" or is blank.
[Parameter] has text with a White background.

How can I do the following?
If [Operator] = "X" I would like [Parameter] background to be Yellow.

[RuralGuy]

Use Conditional Formatting on the Parameter field. BTW, Parameter is a Reserved word and can cause you problems if it is the name of your field. http://www.allenbrowne.com/AppIssueBadWord.html#P

[cadsvc]

The field name is actually [Parameter Text]

[cadsvc]

Can conditional formatting look to another field?

[cadsvc]

I do not have my office laptop with 2007 on it to see if the following is possible??

In [Parameter Text] field -> Conditional Formatting. Is there a sequence choice selection for "Select a field" __[Operator]___ "equal to" __ "X" ___... to make [Parameter Text] red.

[azal]

Usually, I do something like this;

I add the condition field to the report design first of all other fields,
Stretch it to the report width and do the conditional formatting as usual,but the font color should be similar to the conditional back color to hide the field value.

After I test the conditional format, I start adding the other fields on top of the condition field; I add the field itself again if needed, of course with different name.

It works fine all the time and seems professional while in fact a stupid idea behind that.

Try it; I will attach it if needed.

[RuralGuy]

Can conditional formatting look to another field?

The simple answer is YES. Have you tried it yet?

[AZstudent]

I am on the last task on my midterm and I am STUCK. In my report I have, " =Sum([ReEnrollmentFee]) " in my group footer. Well now I have to some how use conditional formatting so that when any of the values are , " equal to 0 " it will appear in red. I'm lost

[RuralGuy]

When you select this control in design mode and right click, don't you have a Conditional Formatting... selection?

[thekruser]

I am in a similar situation. I am incorporating Access in an environment where personnel are still using Excel for everything. Most of the reports I create are done in a way to emulate an Excel spreadsheet. One report in particular is one everyone I work with uses and is used to how it looks.

What I have:
Training Report
-Name
-Course name
-Start date
-End date
-Status

What I am trying to do:
All of the text in a row of data needs to be the same color, but that color is dependent upon the status. For example, if the status is “Completed,” the text should all be red, etc.

The problem:
I can’t figure it out. I can set conditional formatting rules for “cell” that contains the status, but I cannot get that formatting to replicate to the adjacent “cells.” I know that I could reformat the report to have the rows separated in sections by status, but my boss wants the report to look EXACTLY how it did before I started “messing with it,” to use his words.

Though this is a small issue, in my current situation it is a make-it or break-it situation for my employer.

Thanks in advance for your help!

[thekruser]

Sorry for the multiple entries. Can't figure out how to delete the second one.

[thekruser]

Figured this out. Posted the answer on another thread, so I thought I would answer it here as well.

To solve the issue I just described, open the report in design view and select the field(s) you want to apply the conditional formatting to. Go to 'Conditional Formatting' and select 'Espression is' from the first dropdown and enter

[Field]='Arguement'

where 'Field' is the field name in the report and 'Arguement' is the condition you want met for the conditional formatting to be applied. Select your formatting and click ok.