Just curious.

Say i have several fields in a record. and i ONLY want a field called "Price" to have a color of yellow to highlight it if and only if the user selects "YES" for the field called "Charge customer"

So what i want is the color to change, if the user selects "No" for charge customer, the background is say white for the price field. But if the customer selects "Yes" it will automatically highlight the field for price

This should give you the answer.

http://fmforums.com/forum/showtopic.php?tid/174534/post/196505/hl//#196505

HTH

Al

You can also use the feature of [color:blue]Auto Enter and change the text color to reflect the color:

Select the [color:red]Price field in [color:blue]Define Fields, click on the [color:blue]Options, [color:blue]Calculated result, [color:blue]Specify, and then enter this calculation.

Case ( [color:red]Charge customer = "Yes"; TextColor ( [color:red]Price ; RGB ( 1000 ; 0 ; 0 ) ); TextColor ( [color:red]Price ; RGB ( 0 ; 0 ; 0 ) ))

Click [color:blue]Okay, and then [color:blue]Deselect the button Do not replace existing values (if any)

HTH

Lee