How do I highlight a record in an Access Report to show a change?

[Guest]

I have an Access report but I made some changes to the report. I want to
highlight the records on the report so that my Manager will know the changes
I made.

 

[Rick B]

If you have a timestamp field or some way for Access to know which records
were changed, you can use conditional formatting in the report to highlight
the records. You have to have some indicator in the record that Access can
use, though. Maybe you can add a "revised" checkbox to the table and select
it for certain records? You could even build code to have the box checked
any time you complete a change on a record.

 

[Guest]

Thanks Rick. I will work on this.

If you have a timestamp field or some way for Access to know which records
were changed, you can use conditional formatting in the report to highlight
the records. You have to have some indicator in the record that Access can
use, though. Maybe you can add a "revised" checkbox to the table and select
it for certain records? You could even build code to have the box checked
any time you complete a change on a record.