Colour code records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
No.

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