Conditional format duplicates

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

Hi,
I have a form (table) in which one field contains duplicates (case numbers).
I would like ot highlight those in the form, like in Excel, with conditional
formatting.
Is this possible and if so, how?
Thank you,
Caroline
 
Hi,
I have a form (table) in which one field contains duplicates (case numbers).
I would like ot highlight those in the form, like in Excel, with conditional
formatting.
Is this possible and if so, how?
Thank you,
Caroline
Click to expand...

One way (untested) which might work is to include a calculated field in a
query upon which the form is based:

=DCount("*","[tablename]", "[Case Number] = " & [Case Number])

This value will be the count of matches (1 if this is the unique record for
the case).

You could use a condition on this field in the Conditional Format expression.
 
Back
Top