Address changes report

[atadbitslow]

I have a form that displays address information based on fields from one table. Periodically, a user will update an address in this form. My goal is to be able to print a report that shows all the addresses that were changed and have the "changed" data be in bold so the user knows which fields were changed.

What's the best way to accomplish this?? Thanks!

 

[JerryDennison]

You'll need to capture the print event for each record somehow. One way would be to create a table for logging this print activity. This table could have a field for the form's name, the primary key of the record being printed, the date the print activity occured, etc. Then using this table you could compare what is being printed this time to any records printed before and format those records accordingly. It of course would also require that you add new records to your log table so that the process continously updates itself. You could use the OnFormat property to test for those records that need to be made bold and the OnClose event to append the log records. You may wish to include some type of error trapping to insure the report printed correctly before appending any records.