I know this maybe a really newbie question but can you conditional format a query

I want to highlight all empty cells in a query or if they fall below a target rate (a field in one of my tables)

Thanks

Unfortunately, you cannot conditionally format fields of a query, but you can base a form on the query and apply the conditional formats to the form controls holding the fields' data.

Yes, to reiterate what jzwp22 said, and to strongly state something else -

Do not work in queries and tables directly. USE FORMS... they are the User Interface and that's why you have so many more options available, including events, which allow you to do what you want with things. Tables and Queries should be the SOURCE for forms and reports and you do not use the tables/queries by themselves.

[quote=SOS;856400]Yes, to reiterate what jzwp22 said, and to strongly state something else -

Hi Sos,

i am building the query and was going to build a form next but i thought that the condition format would have to be done in the query ie. source control.

Cool aviator Red Dwarfs cool (didnt think much to season 9 tho)

PS Thanks jzwp22 for helping me out much appericated

You're welcome!