how to control display colors depending upon the output variable

[infoscion]

Hi:
I am working on a score card development project. I need to have some way to have an indicator pictorially when the measured metric is withing a certain range. Does MS Access have the capability to handle such a thing on a dynamic basis or are there other platforms that can handle such an issue?
Regards,
Info

 

[Loomah]

Hi
I'd suggest using Excel for this. At the very least you could use conditional formatting to give a traffic light indication.

Not sure if it could be done in Access though.

Happy Friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[TonyJollans]

Hi Info,

I don't know if it helps as you've not given any specifics, but from Access 2K onward you can use Conditional Formatting on an Access Form.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[