Can I show color dots???

[Leo]

I am using Access 2007 – I am trying to determine a way that I can visually indicate the status on projects we are managing.

I need to know if I can create a report that will show dots to indicate complete or non-completed project. However, I would also like to have does dots indicate different status levels by their color (can I make them Blue, Green, Yellow, etc.) and have them change according to the job status? If so, how do I accomplish this???

Thank you.

 

[RuralGuy]

You should be able to use any font on the machine and any color that is available.

 

[Leo]

What I was intending was for the information to show within a report. That way my users can print or view the report from their screens. I just don’t know how to make the color dots associated with a particular job status?

 

[gemma-the-husky]

perhaps have a label on the report, and set the bgcolor for the lable in the form details

format event (maybe print event) - they are the only 2, I think

 

[RuralGuy]

How many different colors do you think you will be using?

 

[Leo]

In regards to colors, I am currently using four colors. Those happen to indicate the different job status levels; Waiting, In Process, Alert and Completed. If I can get the report to work using colors – I may add an additional two (not certain at this time).

 

[RuralGuy]

Conditional formatting allows you to select one of 4 colors as the BackColor of a control; the normal color and three other choices depending on the value of one of your controls. Have you tried that yet?