I hope someone can help me with this one. We are trying to get rid of extra line feeds that are appearing in the text output of our microsoft access reports. The command being used is:
DoCmd.OutputTo acOutputReport, reportName, acFormatTXT, printFileName, False, "", varEncoding
We've tried many methods to rid ourselves of the extra line spaces such as setting the Can Grow, Can Shrink options to TRUE for Report Sections and for text fields. And we've tried widening the fields to make the vertical space smaller but so far, no luck.
We've also considered saving the output to the hard drive as a text file and then just running a filter to eliminate the extra line feeds but that would add precious seconds to each transaction of thousands and so therefore this is unacceptable.
So far it looks like we have to find a solution within the actual report or within the application.
Has anyone else had some success with this kind of issue?