New Line

[Guest]

Hi Anyone!

I have 2 text boxes that need to concatenate together into 1 text box. But I
want them separate by a new line. Like Line 1:....
Line 2:....
I know that in C you can use \n for new line. What do you use in Access?
Thanks

Ngan

 

[Mike Labosh]

I have 2 text boxes that need to concatenate together into 1 text box. But

I
want them separate by a new line. Like Line 1:....
Line 2:....
I know that in C you can use \n for new line. What do you use in Access?

vbCrLf gives you ascii 13 + ascii 11:

txtBox3.Text = txtBox1.Text & vbCrLf & txtBox2.Text

 

[Douglas J. Steele]

vbCrLf gives you ascii 13 + ascii 11:

txtBox3.Text = txtBox1.Text & vbCrLf & txtBox2.Text

Actually, vbCrLf is ascii 13 (carriage return) + ascii 10 (line feed).

Ascii 11 is defined as a vertical tab.