Bold Duplicates (Conditional Formatting)

Question

Hello experts&nbsp;I have a form based on qryLCAmendsI want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCIDhere is what I have but it doesnt bold anything:DCount("*","qryLCAmends","[LCID]=" &amp; [LCID] &amp; "[LCNo]='" &amp; [LCNo] &amp; "'")&gt;1LCNo is text.&nbsp;I am using the "expression" in conditional formatting:&nbsp;&nbsp;Example:&nbsp;&nbsp;How can I do this with conditional formatting?&nbsp;&nbsp;

xps35 · Answer

Try:DCount("*","qryLCAmends","[LCID]=" &amp; [LCID] &amp; " AND [LCNo]='" &amp; [LCNo] &amp; "'")&gt;1&nbsp;

tony2021 · Answer

hello...thank you for the response.&nbsp;&nbsp;I see where the edit is&nbsp;However it seems to bold all records.&nbsp;would you happen to know what the issue could be?&nbsp;&nbsp;I was thinking adding a paren on the 2nd criteria?

xps35 · Answer

It works for me:&nbsp;

Forum Discussion

Bold Duplicates (Conditional Formatting)

3 Replies