Possible to specify color on query?

[GaborH]

I am attempting to build a planning/staffing tool. Projects can be "Booked" or "Probable". Is it possible to specify color of a field, or background, in my CT queries (and reports) on whether the project is "Booked" or "Probable"?

Any hints are highly appreciated.

Thank you!

GaborH

 

[dhookom]

You can do this in a form or report with conditional formatting. It is not possible in a table or query datasheet view.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.