New line problem in memo box

E

Eusi

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
 
O

Ofer Cohen

First back up your data.

You can try something like

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

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?
Click to expand...

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]
 
Top