I have a form with a recordsource set to a table.  One of the fields in the
table is a memo field.  I added a text box to the form and set its control
cource to be the memo field.   This data entry form works perfectly until the
memo field reaches between 2 - 3K.  The user will try to add more text in the
text box and when the form tries to .edit  I get an error.  "Action was
cancelled by an associated object"

Am I doing the edit/update incorrectly.  I have a save button on the form
that does the following:
     Forms![FrmCommentsUpdateAR].Recordset.Edit
    Forms![FrmCommentsUpdateAR]!LastUpdated = Date
    Forms![FrmCommentsUpdateAR]!LastUser = strCurrentUser
    Forms![FrmCommentsUpdateAR]!Contactid = Nz(Me.cboContact, 0)
    Forms![FrmCommentsUpdateAR].Recordset.UPDATE
    DoCmd.RunCommand acCmdSaveRecord

I also tried the following:  the error that I get is "Could not update,
currently locked by another session on this machine"  Although, if I try to
update a row that has a memo field containing fewer charaters, the update is
successful.

Private Sub Form_BeforeUpdate(Cancel As Integer)
     
    Forms![FrmCommentsUpdateAR]!LastUpdated = Date
    Forms![FrmCommentsUpdateAR]!LastUser = strCurrentUser
    Forms![FrmCommentsUpdateAR]!Contactid = Nz(Me.cboContact, 0)
    strnotes = Forms![FrmCommentsUpdateAR]!order_notes
   
End Sub

Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click

    DoCmd.RunCommand acCmdSaveRecord
           
Exit_cmdSave_Click:
    Exit Sub
Exit Sub

Err_cmdSave_Click:
   MsgBox Err.Description
   Resume Exit_cmdSave_Click
End Sub

I know the text box on a form should handle 64 K, but there is some
limitation that is stopping this update.  Does anyone have a solution to this
problem.

Thanks.