Colour code records

I have a query which includes a field - 'Risk'. This is rated on a scale of
1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in
another table. Is it possible to highlight with a shade of colour the records
in the query due to their rating. eg, all risks 8-10 red 5-7 blue etc,
Thanks
Nathan

You can do this easily in a form or report in Access 2000 and later, with
conditional formatting.

1. Open your form in design view.

2. Select the text box to be colour-coded.

3. Choose Conditional Formatting on the Format menu.
Access opens the Conditional Formatting dialog.

4. Set Condition 1 to:
Field Value Is ... Between ... 8 ... And ... 10
and click the red paint in the bucket.

5. Click the Add button at the bottom of the dialog.
Access adds another set of boxes for Condition 2.

6. Repeat setps 4 and 5 to set the values for up to 3 conditions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nathan" wrote in message
...
I have a query which includes a field - 'Risk'. This is rated on a scale of
1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in
another table. Is it possible to highlight with a shade of colour the
records
in the query due to their rating. eg, all risks 8-10 red 5-7 blue etc,
Thanks
Nathan

Thanks for that.
Is there any way to do this however in a table in datasheet view

"Nathan" wrote:

I have a query which includes a field - 'Risk'. This is rated on a scale of
1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in
another table. Is it possible to highlight with a shade of colour the records
in the query due to their rating. eg, all risks 8-10 red 5-7 blue etc,
Thanks
Nathan

No.

Tables are just for storing data.
They are not intended to be the user interface.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nathan" wrote in message
...
Thanks for that.
Is there any way to do this however in a table in datasheet view

"Nathan" wrote:

I have a query which includes a field - 'Risk'. This is rated on a scale
of
1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in
another table. Is it possible to highlight with a shade of colour the
records
in the query due to their rating. eg, all risks 8-10 red 5-7 blue etc,
Thanks
Nathan