Jump to content

Any way to Have field fill color change based on another field


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

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5659 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
 Share

×
×
  • Create New...

Important Information

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