Unable to Update Memo Field in Table

[ianclegg]

I seem to be missing something!

I have a memo field in a table that I need to update. The update data is in a fom field that is either a text field or another memo field.

I have tried updating the recordset by adding the input to a string field and then adding it back but still the field does not update.

my code is listed below

dim pnote as string

recsetjo.edit
pnote = recsetjo("note") - the memo field in the table

pnote=pnote+job1surveyor - the field on the form

recsetjo!note = pnote
recsetjo.update

Also is it possible to separate the entries on the memo field with a vbcrlf


Hoping that some one can help, thanks in anticipation

Regards

Ian Clegg

 

[DCrake]

Try

recsetjo.edit

If Trim(Me.Job1surveyor) <> "" Then
   recsetjo("note") = Trim(recsetjo("note")) & vbcrlf & Trim(Me.Job1surveyor)
End If
recsetjo.update

 

[ianclegg]

Thanks

The field appears to update but I still get nothing in the field when I look at the table. Is it me?

Regards