I have a database program that takes records from a table, sends it to a report, and exports that report to a text file. I need the text file to format with ONLY single spacing between the records. Currently the text file shows/prints with extra line spaces and I canot determine why. I am attaching a copy of the text file (AS EXPORTED) and also text files (CORRECTED-How I need them to look) One is a straight line text and the other file has columns that MUST line up with each item.
Basically I need to remove (or not enter) line spaces for INVENTORY and line up the columns for SALES.
The CODE to export is:
SALES:--> DoCmd.OutputTo acOutputReport, "rptSalesDaily", acFormatTXT, ("C:\Users\juricta\Microsoft\Access\Database Files\Working\LiquorReports\" & vOLCCFileName)