Application.ColumnHistory (Access)

Gets the history of values that have been stored in a Memo field.

A Memo field's AppendOnly property must be set to True for Access to store the change history for the field.

ColumnHistory (TableName, ColumnName, queryString)

Sub colhist() 
 Dim sHistory As String 
 
 sHistory = Application.ColumnHistory("Employees", "Salary", "ID=147") 
 Debug.Print sHistory 
End Sub

Arguments

The following arguments are required:

TableName (String) - The name of the table that contains the Append Only field.

ColumnName (String) - The name of the field to display the history for.

queryString (String) - A String used to locate the record. It is like the WHERE clause in an SQL statement, but without the word WHERE.