Clearing history in Text Box

In Access I have a text field called "txtComments" that retains the history using the following formula:

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

I would like to create a simple button on the Form that allows me to actually clear all the data captured in the history, I am not sure how the code would look like
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
the columnhistory is created for a memo field that have its AppendOnly property set to  Yes

microsoft did not provide a way to delete the history (AppendOnly=yes)

to delete the history you need to set the AppendOnly property to No

if you want to have a copy of the history, create another memo field and run an update query to copy the history to the new memo field, then delete the original Memo field with the history

save the table

to have a clean memo field history, add a new Memo field and set the AppendOnly to Yes
Save the table
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.