Making an Answer's Text Red on a Report

How to highlight a report answer in colored text

  1. Click on the FormAnswers field then click the Expressions icon (F) on the right-side.
  2. Click the arrow next to Appearance to expand.
  3. Click the 3 dots in the Foreground Color field.
  4. Then enter an Iif expression as shown below. Change the Form Answers information for the specific field name (highlighted in yellow).
    Iif([Form Answers.Are valves accessible - Inspection Check] == 'No','Red','Black')
    You can use this same example using different colors or to change background colors as well. Just change the appropriate color or field.