Monitor Field Modification

[J.P.]

Is it possible to monitor the field, like who is modifying that field?

I understand that you can monitor who is creating or modifying the records, but is it possible to find out who is modifying certain field or fields?

[Steven H. Blackwell]

Most welcome. You can add to or substitute such items as the date and time for the User Name,

Old Advance Man

[Steven H. Blackwell]

Yes. This has been discussed here before as I recall. Assume a field called "Address". Define a calculation field of type text with the result STORED. Make the calculation be

If(Address,Status(CurrentUserName), Status(CurrentUserName))

Whenever the value in "Address" changes the field will update.

HTH

Old Advance Man

[J.P.]

Thank You!