Line Return escape character

[Jerry8989]

Within access is there an escape character for line return?

I'm joining two text fields together. When I display them in a text box on a different form I want line1 to be on top of line 2

for example.
textbox1 has "HELLO" and textbox2 has "GOODBYE"
I need to take these two strings concatenate them and put them in a row in a table then when I display it within a form multiline textbox I want it to display like this
HELLO
GOODBYE



Thanks for any help

[RuralGuy]

Try:
[TextField1] & " " & vbCrLf & [TextField2]

[dcrake]

Or you can use vbNewLine as well

[Jerry8989]

I got it working using chr(13) & chr(10). Should I change it too vbCrLf or vbNewLine?
Is there any advantages to those two options?

Thank you to both for your replies

[dcrake]

There is no real difference, its just easier to write, (less keypresses)

David

[Jerry8989]

David,
Thanks for the reply

[RuralGuy]

So are you ready to use the Solved thread tool on this thread yet?

[Jerry8989]

So are you ready to use the Solved thread tool on this thread yet?

Yes, How should I go about doing this?

Thank You

[RuralGuy]

Just follow the link in my sig.