Access Mini-tutorial on changing the color of text in Reports
Really short tutorial in Access on how to change the color of a text box on a report. You can use this to create a "dashboard" style report.
In VB code you can change the text color ( *.forecolor ) property of a textbox which is a long number. In this case the text box is 'Approval_Rating'.
Unfortunately you can't just say Approval_Rating.ForeColor = red but rather you have to use RGB( 255, 0, 0) to generate the correct color. Each parameter for RGB is a number between 0-255. You can look up the RGB value online for a color you want on sites like this or google it.