Is there a way to set a tool tip to show the account name and date/time that the field was last changed?

Hi Dana,

Firstly, you should have a field that contains information about "Last_Change_Date" for a record, then in Set tooltip, enter this:

Get (AccountName) & " " & [TableName::Last_Change_Date]

Hope it helps...

Thanks Henry,

I was trying to avoid creating a second field for every field in my layout. I was hoping that there was a custom function that could be created and added to each field that would note the modifications to only that field.

Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip.

Hi Dana,

Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip.

So, will you actually save the "date" of modification into a field?

I am not sure that the tooltip can actually save all your "modification_date" without having a field to keep their records...

That's what I was crossing my fingers for. If it's not possible then I'll have to see if they would settle for a single field with the modification log. It's just something that an employee asked me about and I didn't have an answer as to whether or not a tooltip was capable of that.

It's one of those "wants" but not necessarily a need.

If is only a matter of knowing who changed the fields and when, look at the Audit Tracking files that have been discussed in the past.

Check out this file Link to see what I mean.

HTH

Lee

That may work. I'll have to take a look at in depth. I know that it will work for other areas that we need a history for the data.

Thanks Lee.

hello friend thanks your good information for me this very helpfull for me