row color in Query

[rickyfong]

1) how to set odd number rows color different from even number rows??
2) how to set the current row color which is different from all others??

Thanks a lot!!

 

[SteveH2508]

This cannot be done in a query as far as I am aware - you will need a form/report and depending on your Access version, some code/conditional formatting/kludges.

 

[Guus2005]

It's like what SteveH2508 said, it can't be done in a query. Nut it can be done using a query.
Conditional formatting on a continuous form can trigger the color for a record.

Let's sat that you have a field called severity. That field could have the following values: Minor, Major, Critical.

Right click on a control in the continuous form, choose conditional formatting.
You can trigger the color of the control by using the value of the corresponding field

If Field1 equals "Minor" then backgroundcolor = vbGreen.

etc.

Share & Enjoy