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
Try:
DCount("*","qryLCAmends","[LCID]=" & [LCID] & " AND [LCNo]='" & [LCNo] & "'")>1
hello...thank you for the response.
I see where the edit is
However it seems to bold all records.
would you happen to know what the issue could be?
I was thinking adding a paren on the 2nd criteria?
Show us your revised expression, please, rather than describe it. The original failed because it used the concatenation operator -- & -- rather than the logical operator -- AND -- in the expression. Perhaps there's still a small typo that needs to be revised.
Hi George, I have described my issue inaccurately on revisit. Its difficult to describe. It is not a must have. I have to look at the data and diver a little deeper on how to describe. thank you...
