Change color on results page of a qry or rpt.

[Sugada]

I would like to change the color of the whole line of my results depending on one of the fields in the results being displayed. For example; If my field name is bed type, then display the results, either in a qry or rpt doesn't matter, in a different color. My data in the bed field is 3-5 different possible answers. So for "open" change the whole row to green. If it is "closed" then change that row to "red". So on and so forth.

Thx, Sugada

 

[Blorf]

Look at conditional formating for forms and reports.

Not available in a query.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.