Export or Convert Access Report to Text File

[leaf3]

Hi,
Is there a way to convert Access report to a MS-DOS text file without loosing format. I tried to publish the report with MS Word and then saving it as .txt file but some format is being lost? Thank You.

 

[RickSpr]

By definition, an MS-DOS text file doesn't have any formatting. Do you mean you want to maintain the column positioning? There is a way to do that, but it's a little tricky getting it right initially.

Add a new printer to your system using the text-only printer driver, and set its "port" to "FILE:". When you print to this printer, a dialog box pops up asking you for a file name. The report will be converted to text. Getting the columns to line up with heading will take some experimentation, because the printer driver will attempt to round column positions to tenths of an inch. A slight difference you can't even see on the screen can cause a field to be off by one position. Rick Sprague