export report to .txt-file

[fvd]

Hi,

I have a MS-access database.
There is a report that i export (via a macro) to a .txt-file, the problem is that in each textfile is a empty line on top, which i don't get rit of...
Does anyone know a solution?
(i saw some threads on ithe internet of people who have the same problem, only answers i found where about how to get rit of empty lines between the lines of text, i had this also originally, now i only have one empty line on top of every textfile, it looks like this):
-------------------------

zerzaertarze
sdfgsd
dsfgdsfg
-------------------------
While it should be looking like this:
-------------------------
zerzaertarze
sdfgsd
dsfgdsfg
-------------------------

I hope someone knows the reason and solution!
It's driving me mad...

Thanks already!
fvd

[Niheel]

I can't find any built in solutions your problem.

I think the easier thing to do would be to create an app that will delete the first line of your apps.

Before you do that, check your database and see if you have an empty field somewhere. It would be the first field. I don't see why access would throw in an empty line.

[fvd]

re

No, there is no empty field.
The report and table are fine, only when you export it as a .txt-file a blanc line is being added, when i expor the same report as a .rtf-file there is NO empty line, so the reason lies not in the table or report.
Only the export to .txt goed wrong.
I don't know why...

If you have any ideas i would be very happy.
Thanks!
fvd

[joeymath]

There is a fix...
The extra blank line at the top drove me insane! I happened to run the export on a different machine, however, and the line dissapeared - it's the printer driver. Set the printer to a generic one in the report page setup and it will go away.