New line Chr()

[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

 

[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.

 

[KARL DEWEY]

Try & Space(7) to add 7 spaces.