Conditional Formatting in Access 2000

[Therat]

I posting this question last week and no one responded!

I can use this function (conditional formatting) correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer sums my data from the detail level and also takes the percent change from one month to the prior month. I am highlighting those percent changes that are above 5% or below -5 percent with a different font and color using conditional formatting. However, it is not correctly formatting the percent changes.

Am I doing something wrong or is this a common problem? Help!!

 

[KevinM]

Try using code rather than the built in formatting feature.

e.g.

If MyValue >5 Then
MyValue.BackColor=255
MyValue.ForeColor=0
End If


hth