Automatic colors

[guy tanguay]

Hi,

How can i make things (text or even record) changed there color base on a what is type in a field ?

ex: I have a field "Priority" wich is a Value list : High, med, Low.

So, if i select "High" I would like the record to appear in a red tint, or at least the text "High" becoming red.

thx

guy

[CobaltSky]

Hi Guy,

One way to do this would be to define the field/s in question as an auto-enter calc based on the priority field, and turn off the 'don't replace existing value of field' option.

The auto-enter calc formula you'd need would be along the line of:

TextColor(TheCurrentField; If(Priority = "High"; 9437250; 0))

- where 'TheCurrentField' is the name of the field you are applying the auto-enter calc to.