conditional formatting to highlight updated records in access rpt

[Guest]

Can this be done? If so, how? We are printing reports weekly on a database
that tracks a few thousand projects. If I could highlight the updates, the
managers could see them easily.

 

[MacDermott]

It's not hard to write code in the Detail_Format event procedure of a report
to change the formatting (e.g. backcolor) -
the issue would be identifying the records which have changed.
Do you have a way of doing that?

 

[Guest]

Not that I know of. I guess that is what I am asking. I was aware that I can
highlight fields, but I don't know how to identify updated fields in Access.

 

[MacDermott]

You'd have to build some way to do that.
Access itself does not, to my knowledge, track when which field (in which
record) was updated.
You could add some functionality to trap all changes and write them out to
another table.
Or you could archive a copy of the database you want to compare against,
then link to it and do comparisons...

 

[Guest]

Thanks for your patience. Some one else suggested that I do that, but I
don't know where to begin, how to trap the changes and how to set up the
function to compare the table with changes to the original table. I will do
some more research and playing around to see if I can come up with the
knowledge. If you have any tips, feel free to respond again. Thank you!