vb fill of text/memo field with line breaks

Question

Access2010:  have a rectangular bound text box where it is desired that when form initially opens (new data entry) that specific text appears within.  Which is no problem as a continuous string.  But if one wanted to attempt some basic formatting as to put a line break between words so they appear stacked rather than side-by-side....can this be done via the Current Event with:  Me.TextBoxName =         ? ?

or is there some other approach I'm not aware of.....

TIA

Answer 1

Try using Chr(13) & Chr(10) for the line breaks.

Default:  "Some Text  " & Chr(13) & Chr(10) & "Next line text  "

Answer 2

alas but that did not work.  resulting in:

Some Text  Next line text 

Answer 3

ah - the issue is Rich Text

changing the field type to Plain Text and this will work....as will:

"Some Text  " & vbNewLine & "Next line text  "

as to getting a new line in Rich Text - from what I read so far it seems surprisingly code intensive......