Cannot Get Conditional Formatting to Work

[hhzyousafi]

I have tried using all of the help guides provided by Microsoft and several other guides I found online; however conditional formatting is simply not working. I have two fields on a report, the report is based on a query, and the two fields are called "ExpectedCost" and "ActualCost". I want "ActualCost" to turn red if and when it is greater than "ExpectedCost". I clicked on "ActualCost" and then clicked on "Conditional Formatting". I selected "Expression" and then put the following expression in the space available: [ActualCost]>[ExpectedCost]

The syntax seems to be correct; however it just isn't working.

 

[JHB]

It is not "Expression" but "Field Value Is".

 

[Mihail]

Should work.
Be aware: Will work only after the field is updated (only after the data is saved to table) so you should leave the control (or to save the record)

 

[hhzyousafi]

Hi JHB,


I sort of tried what you said. I say "sort of" because I don't have the "Rule Type" option when I open up the "Conditional Formatting" window. I tried what you said nonetheless and it still didn't work The Microsoft Office Tutorial also made it sound that easy; but for some reason I can't get it to work.


Hi Mihail,


The report is based on a query and each field has a calculated value - nothing is saving to a table here. Does that mean I can't use conditional formatting?


Regards,


Zohair Yousafi

 

[Mihail]

For me works also in this condition (Report based on a query with calculated fields).

I suspect some corruption. So:

Create a new (empty) report
Copy - Paste the controls and the code from the actual one to the new one.
Do a test.
Create the conditional formats.

Is now working ?

If YES remove the old report and rename the new one as you need.

 

[JHB]

I sort of tried what you said. I say "sort of" because I don't have the "Rule Type" option when I open up the "Conditional Formatting" window.

It sound like you didn't add a "New Rule", (press the button).
I've attached a small example database.