Appending Text to a Memo Field 1

[MagnusFox]

I have a memo box on my form and a button to place text into it when clicked. I need to append text to what is in the memo box now. The memo box may or may not have text in it at the time of clicking the button. So this does not work because it overwrites everything in the memo field:
On Click()
Forms!Form1.Memo = “Text”

I cannot find an ‘append string’ type function to use to add my text to the memo box.

Any help is great.

 

[scking]

& is the append operator

Forms!Form1.Memo = Forms!Form1.Memo & “Text”

Steve King Growth follows a healthy professional curiosity

 

[jamiers]

Is there any way that instead of appending to the end, I can get it to go to the first line, insert the text and send a "return" so the new things are on the first line and the other things are below it?

Thanks Jamie

 

[ottograham]

Jamie:

I've had this question in mind also, but decided to create a "transaction" table which I could identify by date etc.. The transaction table is placed as a subform and works much better for me (I'm using it as a contact database and need to see what I've done with prospects).

If this isn't a solution for you, let me know and I'll work on it for you.

Scott Graham
grahamag@erols.com

 

[scking]

Append the text to the front.

Forms!Form1.Memo = "New Text" & vbCrLf & Forms!Form1.Memo

Steve King Growth follows a healthy professional curiosity

 

[toolman2]

I'm doing the same thing that Magnusfox is doing except I'm prompting for a number whose data will be appended to a field that may or may not have data already in it. How do I get it to add to the existing data based on what's returned from the prompt?
Thanks ahead of time for your help.