I want to have specific field do one of 2 things...

If the value is greater than 0 I want the text to be green or have a green image behind the text.

If the value is less than 0 I want the text to be red or have red image behind the text.

Personally I would prefer the text to change color but I am at a complete loss of where to start.

If you put this calc into the field definition auto-enter calculation, and UNcheck the "do not replace existing value" checkbox, the color of the text will change when you exit the field.

Case (

table::number > 0 ;

TextColor ( table::text ; RGB ( 0 ; 255 ; 0 ) ) ; // green

table::number < 0 ;

TextColor ( table::text ; RGB ( 255 ; 0 ; 0 ) ) ; // red

TextColor ( table::text ; RGB ( 0 ; 0 ; 0 ) ) // black

)

loverly thanks very much

this works beautifully for me to. i need to turn a bunch of fields red if a field on the layout changes. the only fields i am having trouble with are a date field, which doesn't seem to want to change at all. and all the data in a repeating field. i can get the first value to turn but haven't been successful in getting the other values to turn red.

any ideas?

thanks in advance.

Limore