Order Print to Txt File of Report (Access 2000)

L

L.A. Lawyer

I want to print the result of report (call it "Output.txt") to a txt file
using VBA.

How is that done?
 
F

fredg

L.A. Lawyer said:
I want to print the result of report (call it "Output.txt") to a txt file
using VBA.

How is that done?

Look up the OutputTo method in VBA help:

DoCmd.OutputTo acOutputReport, "TheReportName", acFormatTXT,
"c:\YourPathHere\SomeName.txt"

Check the different results using the various acFormat options:
acFormatRTF, acFormatHTML, acFormatSNP, etc.
 
Top