title: how to change font color based off database result
body: <p>In my report, I'd like to change the font color of a text box (text box contains a circle wingdings character, different colors will be used for different statuses). I have a field in my database that has one of 5 options - r,y,b,g, or o for red, yellow, blue, green or orange. Is there a way based on this result for the item to change the color of the textbox to match the corresponding color for each item in the report? Thank you, I am new to crystal reports.</p>
  
  <p>Edit- I tried to right click on the text box where I have placed the circle and then went to formatting. I don't see the formula box like I do when I click on a DB field. Any way around this? I need the colored circle, not just a circle in every item and it needs to relate to that color from the DB field.</p>