Change text colour if CustomerNo occurs more than once

[Jules.]

Hi

I'm new on this forum. I've spent the last couple of days searching for a way to do this but to no avail.

I have a form that lists customer details. If those details change we keep an old copy and use their existing customer number on a new record (Primary key is Date of Registration field + customer number). Therefore within the data we can have several instances of the customer number.

When this occurs i would like to have the records with more than one occurance of a customer number be in bold and colored red.

I'd be really grateful for any ideas.

Thanks

 

[MarkK]

Hi, welcome to the forum.
It doesn't seem like a good idea to me to have multiple records in a table that all represent the same 'real-world' thing. It seems to me that you need to change text color so users know that the data they're looking at might not be accurate. That's a make-work project that results from a weakness in the data model.
My idea is to take a second look at how you store customer data and make sure there is only ever ONE customer record per ONE customer.