In a report, is there any way a record will change color if it's different from the previous record

[richiecheng]

Hi, I am working on a project where I need to color code the report so
it will distinguish if the previous record is different from the
current record. Because the record will have many similar record, so
I am trying to group the record so it's easier to look. In a report,
is there any way a record will change color if it's different from the
previous record.


Thanks for your help.

 

[richiecheng]

Different in what way? How are the "similar" records alike?

Have you explored using the Sorting and Grouping feature to
group the similar records? This would provide a group
header section where you can use a little VBA code to set
the color for the next record or group of records.

Thanks! I think it works out even better