Thursday, February 28, 2013 3:51 AM
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.....
Thursday, February 28, 2013 3:55 AM
Try using Chr(13) & Chr(10) for the line breaks.
Default: "Some Text " & Chr(13) & Chr(10) & "Next line text "
Thursday, February 28, 2013 12:20 PM
alas but that did not work. resulting in:
Some Text Next line text
Thursday, February 28, 2013 1:17 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......
- Marked As Answer by msdnPublicIdentity Thursday, February 28, 2013 1:17 PM