Forms - highlighting values

[neilp]

Within a form I have a column displaying a percentage as an indication of performance.
I wish to have either the text or the back colour change colour when the value is below a set value.

No doubt there is a simply answer but I have not found it as yet so can someone save me hours of searching books and the web by generously pointing me in the right direction.

Thanks

Neil P

 

[Mile-O]

Look up the IIf function - therein lies your solution.

 

[dbrooks]

If you are using Access 2000 or XP you can use conditional formatting. You can find it by opening up the form in design mode, highlighting what you want to change and then go up to Format on your menu bar and click conditional formatting.

 

[neilp]

forms - highlighting values

Thank you for the prompt response - problem sorted