Code for highlighting duplicates in Report

[ryan_kos]

I need code that will highlight duplicates when I run a report. So far I have:

If (Me![Description] = Me![Description]) Then
If Not Me![Description].FontBold Then
Me![Description].FontBold = True
End If
Else
If Me![Description].FontBold Then
Me![Description].FontBold = False
End If
End If

Now I just need someone to tell me how to compare Me![Description] (from line 1) to compare to the next Me![Description] , If you know what I mean
Thanks

 

[David R]

You could run a Find Duplicates Query and base your report off of that, but I'm not sure if that will satisfy your requirements. You will only see the duplicated entries in that case.