Hi everyone,
i am using the ColumnHistory method on a memo field on an Access form. The issue I am having is that it places a time stamp each time I open the form. Is there a way to only have the historical data appear when a new text comment is added in the txtComments field and not every time the form is opened when nothing is entered?
the code I am using is:
ControlSource =ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0))
My form properties are set to
Data Entry No
Allow Additions Yes
Allow Deletions Yes
Allow Edits Yes
Thank you for any help!