Conditional Formatting based on another table (1 Viewer)

[Atthe]

Hi All,

I have a text box within a report that I would like to apply a bold formatting if it matches a record within another table (tblConditionalFormattingBold), Can anyone advise if this is possible?

Thanks

 

[theDBguy]

Have you tried using DLookup()?

 

[Atthe]

Have you tried using DLookup()?

No I haven't could you advise?

 

[theDBguy]

No I haven't could you advise?

Essentially, in your Condition Expression, you would use the DLookup() function to compare the current record to another table. Here's a link explaining how to use DLookup().

DLookup Function (microsoft.com)

 

[Atthe]

Essentially, in your Condition Expression, you would use the DLookup() function to compare the current record to another table. Here's a link explaining how to use DLookup().

DLookup Function (microsoft.com)

I am struggling with the syntax, my main table is tbltools and the field is Tool Type and the table I want to field matches against is tblConditionalFormattingBold and field Bold

Can anyone help?
Thanks

 

[theDBguy]

I am struggling with the syntax, my main table is tbltools and the field is Tool Type and the table I want to field matches against is tblConditionalFormattingBold and field Bold

Can anyone help?
Thanks

It might be easier to help you if you could post a sample copy of your db.

 

[arnelgp]

here is a demo.

 

[Atthe]

here is a demo.

Thanks for your time, the problem I have is there are over 80 records in my tblConditionalFormattingBold and they could all be in the report so I need to check against all of these not just one and format bold all the matches. Is this possible?

Thanks

 

[arnelgp]

concatenate all your "conditions" into a string. use recordset to do this.
use Instr() function to test if your field in report can be found inside the string.