Exporting to TXT file - Am I missing something?

  • Thread starter Thread starter ManningFan
  • Start date Start date
M

ManningFan

I'll try to give the basics here and not overload anyone with
information.

I'm exporting some data to a text file. I need to print a header, loop
through some code pulling necessary info, then print a footer.

I'm using the following code:
Print #2, strCodeLine

The problem is, I use it to print the header, body and footer. In
between each section it's automatically inserting a blank line, which
is screwing up what I'm trying to do.

Is there any way to force Access to NOT print a blank line each time it
runs that line of code?
 
I can only think of two possibilities.

1) Print # normally outputs a CR LF after whatever you tell it to print,
so if strCodeLine itself ends with CR LF you'll get a blank line.

2) Somehow your code is going once too often round its loops, and
calling Print # an extra time with an empty strCodeline.

BTW, Help for the Print # statement mentions that you can stick a ';' on
the end of the statement to suppress the usual CR LF.
 
Back
Top