Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Apr 26, 2026
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...
access
  • XPS35's avatar
    XPS35
    Apr 26, 2026

    Try:

    DCount("*","qryLCAmends","[LCID]=" & [LCID] & " AND [LCNo]='" & [LCNo] & "'")>1

     

XPS35's avatar
XPS35
Iron Contributor
Apr 26, 2026

Try:

DCount("*","qryLCAmends","[LCID]=" & [LCID] & " AND [LCNo]='" & [LCNo] & "'")>1

 

Tony2021's avatar
Tony2021
Steel Contributor
Apr 27, 2026

Odd. I dont know what it is.  maybe the form is corrupted.  anyways I think i have the correct codes.  thank you.