Can I add text to a memo field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 16 Jun 2005 05:32 GMT

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

Reply to this Message

Bob Howard - 16 Jun 2005 05:40 GMT

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

> I have a memo field that carries "Notes" about each member.
>
[quoted text clipped - 6 lines]
>
> Robin

Reply to this Message

Ken Snell [MVP] - 16 Jun 2005 13:47 GMT

UPDATE MyTable
SET MyMemoField = MyMemoField &
" My New Text";

Signature

Ken Snell
<MS ACCESS MVP>

>I have a memo field that carries "Notes" about each member.
>
[quoted text clipped - 6 lines]
>
> Robin

Reply to this Message

Robin Chapple - 16 Jun 2005 20:27 GMT

Thanks Ken

>UPDATE MyTable
>SET MyMemoField = MyMemoField &
>" My New Text";

Reply to this Message

Ken Snell [MVP] - 16 Jun 2005 23:26 GMT

You're welcome.

Signature

Ken Snell
<MS ACCESS MVP>

> Thanks Ken
>
>>UPDATE MyTable
>>SET MyMemoField = MyMemoField &
>>" My New Text";

Reply to this Message