Need Help desperately...............Code to Format Report Page

[Razzie33]

Hi-- can someone please help,
I am exporting a report to a txt file that has to be fed into another system. The probalem i am having is that Access puts in spaces every 6,7,or 8 records (there is no pattern) and the page breaks are either 4 or 3 spaces. I dont want there to be any spaces at all. When it is printed out from the access report there are no spaces anywhere-- it is only when it is in the text file. Also after the page break it treats the first line of records as the header even if it is not. Is this from me or from Access' internal formating

i have tried deleting the acPageBreak -- it didnt work

I have tried saving it as rtdf, txt, msdos text-- nothing seems to work or to stop it

can i do it through code?
is my best bet just to run a macro on the txt after it has been exported? the problem with that though is that there is no set pattern of where the breaks are & how many there are--
please if anyone has any suggestions, ideas, anything please please help!
thank you

 

[JerichoJ]

Are you trying to create a comma delimited or fixed width text file?

If so, look at the online help for

DoCmd.TransferText

You can create a query that has the fields and records that you want to export. Then using DoCmd.TransferText you can export that query to a text file.

This is the preferred method.

If you need further help after giving this a try, let me know.

 

[Razzie33]

im not having a lot of luck with the online help files-- they seem to be pointing mostly to error messages.... or to running a macro-

i see the macros have the 'transfer text ' too but i am uncertain of how you would tell the text where to go like different lines?