New line problem in memo box

[Guest]

Hello

I'd like to add a string to some existing text in a memo box, but I'd like
the string to appear on a new line. Any ideas as to how I can achieve this?

Many thanks in advance

Eusi

 

[Guest]

First back up your data.

You can try something like

UPDATE TableName SET TableName.MemoField = [MemoField] & Chr(13) & Chr(10) &
"More text"

 

[John Vinson]

Hello

I'd like to add a string to some existing text in a memo box, but I'd like
the string to appear on a new line. Any ideas as to how I can achieve this?

If you're typing into a Form control bound to the memo, you can either
press Ctrl-Enter to insert a newline character (actually Chr(13)
followed by Chr(10), CR - LF); or set the textbox's Enter Key Behavior
property to "New line in text" (the phraseology may be off but that's
the gist).

John W. Vinson[MVP]

 

[Guest]

Thanks guys, you've sorted my problem!

eusi