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.

Example and text of Access mini-tutorial

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.