How can I color code a field on an Access report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a report that performs calculations that are stored in Text
boxes. One of the Text boxes divides two values to give me a percentage. I
would like to place another Text box under the calculated value that says
something like "If the calc'd value is <= 90, color code the box to green,
else if the value is between 90.1 and 97, color code the box yellow, else
color code the box red". Is this possible to do in a report, and what would
the code look like?
 
Just use the built-in conditional formatting. No code needed.

See the help files for more details.

Rick B
 
Back
Top