coloring a field according to value

[happydermis]

Hi all,____Is there a way to color a field according to its value? Something like: IIF(field<100,color(green), color(red))____Thanks! Dekers

[kfleming]

You would need two calculated fields.__The expression of the first would be:__IIF(field<100, field, blanknum())__Place this field on the layout and set its color to green.____IIF(field<100,blanknum(), field))__Place this field on the layout directly on top of the green field and set its color to red.____Regards,__Kathleen__R&R Support

[happydermis]

Many thanks Kathleen!__That saved me at least 5 hours of searching ;-)____Dekers