How to add a new line in SQL statement.

[rbasram]

strSQL = &quot;<Title> &quot; & rst!Title & &quot;</Title>&quot; & (here is where i want t new line) &quot;<Author> &quot; & rst!AuthorName & &quot;</Author>&quot;

I am trying to put a new line in the sql statement because I want to print the whole data into a text file. Is there any new line constant so that after evey field I have a new line..

the output of the above code is

<Title> this is the title<Author>this is the author

required output
<Title> this is the title
<Author>this is the author

Please help....

 

[braindead2]

you could try
vbcrlf
but I don,t think it will work here

 

[rbasram]

It worked thanx a lot