Highlight Changes in Form

[MHamid]

Hello,

Would it be possible to highlight any/all updated fields in a form inAccess?
I’m looking to highlight the first update instance in Red with theupdated date.
Then I need to highlight any second updates in Blue.
Is this possible?

Thank you

 

[xenou]

I'm just questioning why you would use the form after update event. That happens when you save the entire record, not while the form is being edited. I still don't quite understand why a user wouldn't know they changed a field when they literally just changed it themselves. You don't have to narrow anything down.

 

[MHamid]

The purpose of highlighting the field that was edited to blue is so that another user can see what was updated so that they can in turn to what they need to do with that information.

 

[alansidman]

Look at this link from Denis Wright's web site on tracking changes to a database.

http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm

 

[MHamid]

I just implemented the code from the link with a few tweaks.
Now I just need to figure out how to update to blue font these changes that were made.