Highlighting specific names

[DennisJones]

This should be easy but I can't see how to do it efficiently. I have a small application that books people in for a competition and creates a record for each. At most I get about 500 people registered in a day, I need to be able to highlight when anyone from a specific list of names (no more than about 15 people) comes forward and tries to register. I guess this is some form of CASE statement where I compare surnames against a text array or is there an easier way?
ps I don't mind if it's hard coded into the VB code rather than as a look up table.
Thanks
pps you can do this with conditional formatting but the limit there is three.

 

[The_Doc_Man]

If there is a guarantee as to the form of the name they will present (or a good instruction regarding the way ALL names are entered), you can look into the IN operator, used as

SELECT ...... WHERE .... AND [EntryName] IN [RestrictedTable] AND ....

This could also be managed as a DCount( [EntryName], [RestrictedTable] )

Look up both IN (as a query relational operator) and DCount (as a Domain Aggregate) for two ways to skin this particular cat.

Be warned that either method is going to be very sensitive to the way in which the names are originally entered in the table of restricted applicants and in the form where they are trying to enter.