In Microsoft Office Access 2007, the Append Only property for a Memo field in a table is set to Yes. When you change the value of this property to No, the column history for the Memo field is lost.

Back to the top

This behavior is by design.

Back to the top

When you change the value of the Append Only property to No, Access 2007 no longer tracks changes to the Memo field. Additionally, the history of all the changes to the Memo field is deleted.

Back to the top

Steps to reproduce this behavior

1.	Start Access 2007.
2.	In the New Blank Database section, click Blank Database, and then click Create.
3.	On the Create tab, click Table.
4.	Click the Microsoft Office Button, and then click Save to save the table.
5.	In the Table Name box, type MemoTable, and then click OK.
6.	In the Navigation Pane, right-click MemoTable, and then click Design View.
7.	In the Field Name column, type MemoField. Then, in the Data Type column, click Memo.
8.	Under Field Properties, set the Append Only property to Yes.
9.	Click the Microsoft Office Button, and then click Save.
10.	Create a history for a record. To do this, commit several values to the Memo field in a single record.
11.	In the Navigation Pane, right-click MemoTable, and then click Design View.
12.	Click MemoField.
13.	Under Field Properties, set the Append Only property to No.
14.	Click the Microsoft Office Button, and then click Save to save the table changes.

Back to the top