I have a report with values that are sorted in the underlying query to be grouped together if they are the same; i.e. for a column of names: if there are three "Jim" values, they are grouped together. I would also like to use conditional formatiing for the control box in the form to turn the "Jim" entries red. I know how to do this in Excel but it's not quite the same. Wanted to use the Tools, Conditional Formatting function in Access to accomplish this.

Does anybody know what I should use in the "Field Is" or "Expression Is" box of the conditional formatting "wizard"?

If you want the particular text box that is bound to the field to turn red, then you use the Field Is part and put in "Jim".

If you want a different part of the form, or report, to turn red then you go to that control and use Expression Is to specify to turn red if your textbox with Jim in it has "Jim" in it.

Hi Bob!

I probably didn't explain myself well enough. The table may have:
Jim, Bob, Jim, Joe, Mike, Jim, Joe, Terry, Rick . . . the query groups the like names together, but I want the control box conditional format in the report to color only those values that are the same. So in the example above, it would color the Jim's, and Joe's red in the report (kind of like the identify duplicates in a column for Excel). The problem is that I have many different "same value" known and unknown values (based on current and future user entries) so I cannot identify all the instances in the Field Is or Expression Is box.

Thought there might be some command to identify "duplicates".