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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text box background color depending on value in Label Reports 1
Access 2007,reports,VBA 2
Run select query from VBA code where criteria comes from a multi select ListBox 2
Change font color in report 2
add color in report depend on data value 5
Using a Calculated Control in a Report 2
Hiding a #Num! occurrence in a report output 4
Highlight between 3 fields 4

Back
Top