Conditional formatting not working on DLookup

[gojets1721]

I have a text box in a report whose control source is using a dlookup formula.

When applying conditional formatting to that field, the formatting only appears if the user actually clicks on the text box. It doesn't always appear and also doesn't appear when the report is export to PDF.

Any suggestions on how to fix?

 

[arnelgp]

then, use query and add Calculated column that will dlookup the value.
use the query as recordsource of your report.

 

[gojets1721]

then, use query and add Calculated column that will dlookup the value.
use the query as recordsource of your report.

I have a bunch of different text fields throughout the report though that I was hoping to use conditional formatting on; there's 4 different tables that I'm using dlookups on so I don't think all could be pulled into one query

 

[gojets1721]

I was able to figure it out. I had back style set to transparent and not normal. Thanks