Highlighting Duplicates with Conditional Formatting

[Jusenkyo]

Hello all

I have a form with a list of contracts populated by a function.
What I want to do is to use conditional formatting (the database is an ADP), to highlight any duplicated contract numbers.

Anyone got any idea if this can be done?

Cheers
J

 

[gol4]

add an addition field to the form that includes a record count. Any that is greater then 1 set condition based on that field.

 

[TheAceMan1]

How are ya Jusenkyo . . . . .

Instead of [blue]curing the problem[/blue] (work around it), you should [purple]fix the problem![/purple]

I'd find the point [purple]where duplicates can occur during data entry and take care of it there![/purple] [blue]A good DB doesn't allow duplicates after data entry![/blue]

A great many of us here can easily help you with that!

[purple]Just my opinion . . .[/purple]

See Ya! . . . . . .

 

[Jusenkyo]

Good idea Gol4! Cheers.

And TheAceMan1, This is not a problem that can be sorted. The duplicated data arises from our legacy systems that allow contracts to go through various stages of registration in the same table, so I am viewing a complete history of some contracts.
Therefore duplicates are inherent in this table.

Ill have a look at that record count thing though. Cheers Guys!

 

[TheAceMan1]

Jusenkyo . . . . .

Understood . . .

I can give ya code for it, but is the ContractNumber field text or numeric?

See Ya! . . . . . .

 

[Jusenkyo]

Its all good, Gol4's idea worked. Cheers anyways!