Print # Statement

[Guest]

I have a need to create a text file using the print # method. The problem
with this method is that it adds an extra blank line at the end of the file.
Is there a way to stop this from happening? I want a file that has no blank
lines. I think by default, access is throwing in a line feed and carriage
return.

thanks

 

[Brendan Reynolds]

A semi-colon at the end of the statement prevents the Print # statement from
starting a new line ...

'prints the text and starts a new line
Print #Whatever, "one"

'prints the text without starting a new line
Print #Whatever, "two" ;