Colour code records

[Nathan]

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

 

[Allen Browne]

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.

 

[Nathan]

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

 

[Allen Browne]

No.

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