Page 1 of 1

coloring a field according to value

Posted: Mon Nov 29, 2004 12:32 pm
by 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

=> coloring a field according to value

Posted: Tue Nov 30, 2004 7:08 am
by 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

==> coloring a field according to value

Posted: Wed Dec 01, 2004 11:04 am
by happydermis
Many thanks Kathleen!__That saved me at least 5 hours of searching ;-)____Dekers