Export Report to Fixed Text width

[kirstenlargent]

I need to export an Access Report to a Text file with the fields each being a fixed width. What is the easiest way to format the report so I can tell what space a field will start at? Would any certain font in the design view help? I have been doing it field by field by trial and error, but that is taking forever!! Any suggestions would be greatly appreciated!!

 

[CosmoKramer]

Check out Access help for the TransferText method. If you export a fixed width file the field sizes will be used to determine spacing......

 

[kirstenlargent]

The TransferText looks like it will only work for a table or query, and I need to export a report. I need to export a report because I need certain data only in the first row (class name, number, date) and then I need different data in the rest of the rows (class participants). The only way I could think of to do that was through a report. But it doesn't look like the TransferText will apply to a report. Any other suggestions?

 

[CosmoKramer]

Take at look at the OutputTo method in Access help. This will allow you to export a report to a variety of file formats. Something like this:

DoCmd.OutputTo acOutputReport, "YourReportName", acFormatTXT, "YourTextFile.txt"