Long Comment is being truncated

I am adding records to a table 'tblCallLog_Worksheet with this code:

'debug.print "Loading the Output Record"
'debug.print "wk_gComment"; wk_gComment
'debug.print "insertComment"; insertComment
'
Dim wkBRT As Long
Dim wkPropertyID As Long
'
'Debug.Print wkComment
'
'
'///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
'

Dim rsOut As ADODB.Recordset
Set rsOut = New ADODB.Recordset
rsOut.Open "tblCallLog_Worksheet", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
'
Dim rsIn As ADODB.Recordset
Set rsIn = New ADODB.Recordset
rsIn.Open "tblSelectedBRTsToProcess_Local", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
'
If rsIn.EOF Then
    Exit Sub
Else
    If rsIn.RecordCount > 0 Then
        '
        rsIn.MoveLast
        rsIn.MoveFirst
        '
        While Not rsIn.EOF
       '     '
            wkBRT = Nz(rsIn!BRT, 0)
            wkPropertyID = GetPropertyIDFromBRT(wkBRT)
            '
            With rsOut
                .AddNew
                    !BRT = wkBRT
                    !PropertyID = wkPropertyID    '  = 0          
                    !CallLogHdrID = insertCallLogHeaderID
                    !User = insertUser
                    !DateTimeAdded = insertDateTime
                    !Comment = insertComment
                    '
                .Update
                '
            End With
            '
            rsIn.MoveNext
        Wend
            
    End If
End If
'
rsIn.Close
Set rsIn = Nothing
'
rsOut.Close
Set rsOut = Nothing
'

Select allOpen in new window

This is about as simple and straightforward as it gets.  The issue is that long comments are being truncated when added to the output file.
I attached the layout of the output file

I have the debug.prints (currently commented) above the code that adds the record to the output table.   The debug.print showed the contents of the filed 'insertComment' contained the entire comment.  However, the record created has the comment truncated.  The 'Comment' field in the output table is defined as memo.

Anybody have an idea of why the comment is being truncated?
TableDef.doc