conditional formatting based on each change in value

[sal]

In Form datasheet view Access provides an "every other record" pattern of background color formatting across rows.

Is there a way, perhaps through the use of "Expression Is" in conditional formatting to change this pattern to repeat based on changes in the value of the first column? My goal is to group repeating values by background color.

 

[Galaxiom]

You cannot do it in the Alternate BackColor but you could change the BackColor of the controls using ConditionalFormatting. One answer lies in a clever manipulation of the recordsource query.

It could be done if you can include an extra field based on the sequence of the grouped field in the recordsource query. I would aim to produce a boolean field. Note this field does not need to be visible.

Another way would be to produce a recordset with a list of the values in sequence and manipulate the ConditionalFormatting using VBA.