Append Text (2000)

Topic

New Reply

I have a memo field in a table – to be used add comments related to a record. Is there a way to quickly add or “append” text into this field? I have a button on a form that creates a letter in Word. Can this same button action send some text into the memo field (“Letter sent on Feb 2 by David”). It would have to APPEND text, not overwrite existing text already in the memo field.

THANK YOU! I’ve been looking all over the place for the command or action that can do this, but I’ve found nothing so far.

Reply | Quote

Replies

Not sure in what situation or event you need to do this but something like this should work:

Me.MemoControl = Me.MemoControl & ” Text you want here”

Reply | Quote

THANK YOU! This works beautifully. (You can tell I don’t know VBA – I am amazed everytime it works.)

Reply | Quote