Is it possible to have a field/calculation that shows the date that a particlular text field is modified? The reason I want to do this is so I can have a layout/table that I can look at and see the dates that text has been entered into this particular text field.

I know I can show the date modified for the entire record, but don't know if it can be done for just a particular field.

LR

Depending on how many fields you want to show modified date for you can set up a clone of a field with a auto enter calc ie: Name Clone = Name then have a date field with a calc such as Case(Name Clone <>Name, Today,Name Clone = Name,DateToText("")) that way if Name field is changed date will enter.

Dean

Hi LR,

What you are looking for is sometimes referred to as "Auditing". This allows you to track 'changes' to specific fields.

I have a sample file that shows how you could implement a "History" field to document any 'changes' to another specific field. It basically 'appends' any change to a field to a "History" field. You can also have it append the date, time, user, etc. to the "History" field.

E-mail me ([email protected]) if you would like to look at it.

Bob Kundinger