I Have uploaded a small db, would like to highlight same first names, and same surnames.(Different Colours) I am working in access 2003, I have entered the code in the conditional formatting feild on the report, Hope this is correct. When i entered as Code on detail section, On format event, i get a compile error.