Jump to content

Traffic Light System, Change Text Color?


This topic is 6467 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

)

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

This topic is 6467 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.