April 8, 200520 yr 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
April 8, 200520 yr 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.
Create an account or sign in to comment