If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
*Another* OLK 2002 sendmail/SMTP problem | steviegb | General Discussion | 11 | March 23rd, 2005 12:59 AM |
Make Change Case in Excel a format rather than formula | Kevin | Worksheet Functions | 1 | March 18th, 2005 08:53 PM |
0x80040109 error when sending from SSL SMTP | krouse | General Discussion | 7 | March 15th, 2005 01:55 AM |
Filter Records Code Needed | Dave Elliott | Using Forms | 1 | October 5th, 2004 04:39 AM |
Delete Records with Code | MaryF | New Users | 5 | June 30th, 2004 01:40 AM |