Memo Field Update Loses Data

  • Thread starter Thread starter dbl
  • Start date Start date
D

dbl

Hi I have a memo field called "Comments4" I use this field to record notes.

I have a Check Box which I use to update several fields when I am closing
down a record. I added the following code:

Me.Comments4 = "FILE CLOSED" & Now()

But it deletes all of the data in the Comments4 field when it inserts the
"FILE CLOSED" and the date.

Is there away round this or can it not be done?

Thanks Bo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set focus to end of data 3
Can't Update Record When Pasting to Rich Text Memo Field 1
Arranging text in a memo field 2
Memo Field in Form 4
Record Corruption 30
Memo fields on mouseover 7
memo field shows last record 3
Text in Access memo field 5

Back
Top