Highlighting Record if Value is Negative in Report

[RJ]

I have a calculated field which does the following...

=IIf([lytd]=0 Or IsNull([lytd]),"",Format(([ytd]-[lytd])/
[lytd],"0%"))

I want to be able to have a text box behind my records
appear in yellow when the value of a text box is less then
0. I know this can be done in the Forms but i'm unsure of
how to do this within the Report since there is no "On
Current" event.

Any help is appreciated,

- RJ

 

[Duane Hookom]

You can use the On Format event of the report section much like you would
use the On Current event of a form.