Alternate back color

[jsic1210]

In a report, is there a way to set alternate back row colors that are not every other row, but instead when the field value changes? For example, my rows may show as following:

Alliance Co.
Capital One
Capital One
Morgan Stanley

I want Alliance to have a white background, both Capital One fields to have a gray background, and Morgan Stanley to have a white background.

Thanks in advance!
Jeff

 

[MSAccessRookie]

You should look into Conditional Formatting. It might be a good start towards what you are looking for. The only thing that I would be concerened about is the number of variations that would be required.

Another option might be writing some VB Code for the ON Change Event that changes the Background Color as required.