2 Replies Latest reply on May 11, 2011 11:33 AM by jetmaster

    Text Color Based on Field Value

    jetmaster

      Title

      Text Color Based on Field Value

      Post

      Is there a way to set the field color text based on the value of a field from a value list?

        • 1. Re: Text Color Based on Field Value
          philmodjunk

          Do you want to simply display a specified color on the layout or do you want to apply color formatting to the actual text? both can be done.

          Here's the display only color change:

          Say your value list field has the values Red, Green, Blue

          Right click the text or text field while in layout mode and select Conditional format.

          Add three conditional format expressions:

          Table::ValueListField = "Red"
          Table::ValueListField = "Green"
          Table::ValueListField = "Blue"

          For the first expression, select a red text color. Select Green for the second and Blue for the third.

          • 2. Re: Text Color Based on Field Value
            jetmaster

            Wow they have everything in here somewhere! Thanks!