none
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

    Thursday, February 28, 2013 3:51 AM

Answers

  • 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......

    Thursday, February 28, 2013 1:17 PM

All replies

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

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

    Thursday, February 28, 2013 3:55 AM
  • alas but that did not work.  resulting in:

    Some Text  Next line text 

    Thursday, February 28, 2013 12:20 PM
  • 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......

    Thursday, February 28, 2013 1:17 PM