Originally posted by frankgh
I need to export a report to txt.
the problems i'm having is getting extra spaces after or before the data,
i need it to be in a fixed number of charaters.
i have search this and otehr forums, but couldn't find the solution.
thanks in advavce
I assume you want to create a text file of fixed field lengths. If this is the case, use the file - export option in Access, and export the query or table that is the data source for the report. Use fixed width format, and use the advanced options in the export wizzard to save a specification.
If you want to automate the process using VBA, on a button click event do the following: