Jeff please help..How to add a new line in the 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....

 

[Aivars]

Create the simple report!
Aivars

 

[jebry]

Hi!

The constant to go to a new line is vbCrLf. It's hard to tell exactly what you are trying to do, so I don't know if that will be useful or not.

hth Jeff Bridgham
bridgham@purdue.edu