Print Access report in DOS format

[katz]

Hello,
I need to send Access Invoices to a customer, they are using IBM AS400 with
4224 printer which is 1 of the system 3x printers attachable to the AS400.
They want the invoices in ascii format.
What I did is,I print the Invoice in Preview and save it as Text File and I
Email it to them. If I send them one invoice only, they can print it, but if
I combine more invoices, the first page prints ok but the second page is
off. It looks like a form length problem of some kind or maybe an end of
form control character. I'm not sure.
Is there a way to output the report in ascii format?

Thanks everybody

 

[Arvin Meyer [MVP]]

You can output a report as text and I would try outputting each invoice as a
separate report. Either use:

DoCmd.OutputTo acOutputReport, "ReportName", acFormatTXT, "ReportPath.txt"

or use the older, but always workable Open syntax:

Open "C:\Invoice:" For Output As #1
Print #1, rst!InvoiceNumber
...'.
Close #1