Access Code

[Steve]

I am trying to color code a field in my report. I want a
field to be RED if it is large than a specified field. I
can not use conditional formatting because the specified
sield will change in value.

Thanks for your help

 

[Allen Browne]

You should be able to use Conditional Formatting, setting an expression such
as:

[SomeOtherField]

That would be much more efficient than using code it the Format event of the
Detail(?) section.