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

  • Thread starter Thread starter richiecheng
  • Start date Start date
R

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.
 
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.
Click to expand...


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.
 
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.
Click to expand...

Thanks! I think it works out even better
 
Back
Top