Prev: WOORDEN
Next: Multi Axis Pivot Chart
From: Caroline on 26 Feb 2010 11:19
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
From: John W. Vinson on 26 Feb 2010 18:34
On Fri, 26 Feb 2010 08:19:01 -0800, Caroline
<Caroline(a)discussions.microsoft.com> wrote:

>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.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: WOORDEN
Next: Multi Axis Pivot Chart