New line Chr()

A

anna_717717

Hi all,

I need to join two text strings together. I've used Chr(13) & Chr(10) to
force a new line. How can I indent the text on the new line? I've tried
Chr(13) & Chr(10) & Chr(9) but this doesn't work. What do I need to do?

Thanks
 
K

Klatuu

Where are you trying to display this string, because what you are doing is
correct.

But, for readability, I sugges using the intrinsic VB constants:

x = "This is the First Line" & vbNewLine & vbTab & "This Line is indented"

Except in queries. Queries don't understand the contstants.
 
Top