I have a form with a comments TextBox that when saved, updates the History text box, using the code in the history text box
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
What I need to do is clear the data in the comments textbox
I have tried
Me.Comments.Value = Null
and
Me.Comments.Text = ""
But none seem to work.