Conditional Formatting in Query

[jbc]

Hello,

I want to use the same query for different forms and reports. Can I create
conditional formatting on a calculated field so that it carries over to the
forms and reports?

For instance:

AmountDue:[Dues]-[Payment]

if amount more than 0, appear in red.

Right now I've been using conditional formatting in each form and report.

Thanks.

jbc

 

[Rick B]

You would do the formatting in your forms, not in your query.

 

[fredg]

Hello,

I want to use the same query for different forms and reports. Can I create
conditional formatting on a calculated field so that it carries over to the
forms and reports?

For instance:

AmountDue:[Dues]-[Payment]

if amount more than 0, appear in red.

Right now I've been using conditional formatting in each form and report.

Thanks.

jbc

No you cannot.
Do the formatting in the form or report.