Conditional format duplicates

[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

 

[John W. Vinson]

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

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.