Can I add text to a memo field

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a memo field that carries "Notes" about each member.

At times I need to add the same comment to many members selected by a
criteria in the query. Is it possible to use an update query that will
retain the existing contents and add a common comment to the qualified
records?

Thanks,

Robin
 
I've never done this, but it would seem that if you used some code to fetch
the existing data, add a couple of carriage returns, and then add the new
comments --- it just might work!

A = A + Chr(13) + Chr(13) + B
 
Back
Top