conditional formatting a report with expression using in (…)

[chelle1]

I'm trying to do conditional formatting on a field in a report using an expression looking for a list of values using a subquery
I don't get an error, it just doesn't work.

If I hard-code the list, it works but not using the subquery

Suggestions would be greatly appreciated

 

[ranman256]

Is the formatting IN the subReport?
(As opposed to the master report)

Is the value in subReport ?

 

[chelle1]

It's in the Detail portion
I don't think there is a subReport
I hope that answers your question. Sorry, I haven't worked in Access reports in over 20 years and I'm just wanting to add the conditional formatting on an existing report someone else wrote.

 

[welshgasman]

I do not believe you can expect any sort of query statememt in CF?

Simple comparisons only?
Possibly bring the result in as part of the query, then test for that.?

 

[chelle1]

I do not believe you can expect any sort of query statememt in CF?

Simple comparisons only?
Possibly bring the result in as part of the query, then test for that.?

Thank you for the feedback. I was hoping not to have to touch the existing query used in the report.