New Line

A

Access Front End

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
 
M

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

vbCrLf gives you ascii 13 + ascii 11:

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

Douglas J. Steele

Mike Labosh said:
vbCrLf gives you ascii 13 + ascii 11:

txtBox3.Text = txtBox1.Text & vbCrLf & txtBox2.Text
Click to expand...

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

Ascii 11 is defined as a vertical tab.
 
Top