USING "MAX" TO APPLY CONDITIONAL FORMATTING

[pbisaillon]

I am trying to change the color of a certain field when the condition of another field has been met. I am not sure of the code needed to do this.

Example: I am performing calculations based on dates. I want a certain field to change colours based on the MAXIMUM or latest date value of the calculated field.

make sense?

Thanks..

 

[hermanlaksko]

If me!yrfld>1000 then me!yrfld.backcolor=123456

or mayby a select statement is more to the point:

select case me!YrFld
case 100
me!YrFld.Backcolor=123
case 200
me!YrFld.Backcolor=1235
case 300
me!YrFld.Backcolor=12356
case else
me!YrFld.Backcolor=12356789
end select

Herman