Conditional Formatting in Access 2007 Report

Question

I have created two reports in Access 2007 that are virtually identical except for the data source. In both of them I have set up conditional formatting on a field to make the font italic when

Expression is [Status]="Holding"

In one of the reports the conditional formatting is applied and in the other it isn't. I've even tried setting it to

Expression is [Status]=[Status]

but the conditional formatting still isn't applied. Any ideas on what is going wrong?

Answer 1

I cleared the conditional formatting from all the text boxes where it was set. I then again set the conditional formatting to

Expression is [Status]="Holding"

This time it worked! Very strange, but at least it's working now.