Forum Discussion
Solved
Bold Duplicates (Conditional Formatting)
Hello experts I have a form based on qryLCAmends I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID here is what I have but it doesnt bold anything: DCount("*","qryLC...
Try:
DCount("*","qryLCAmends","[LCID]=" & [LCID] & " AND [LCNo]='" & [LCNo] & "'")>1
It works for me: