Unable to export report to text

  • Thread starter Thread starter Freida
  • Start date Start date
F

Freida

I have an access report that I cannot export into a text file. When I do
the export, it creates the file but there is no data in it, not even a
carriage return. I do not get any error messages. It works when I export it
into word, but I need the text format straight from access.

The purpose of the report is to format my data for the text file. The code
I am using to format the report is

="COMM " & Format(Date(),"yymmdd") & RTrim([EAS ID]) & "-3" &
Format([VenCount],"00") & Space(16-Len(Trim([EAS ID]))) & "1001" & IIf([Total
Vendor Comm]<0,Format([Total Vendor Comm]*-100,"0000000000000") &
"0Y",Format([Total Vendor Comm]*100,"000000000000000")) &
Format(Date(),"yymmdd") & "COMM C" & Space(8) & RTrim([EAS ID]) &
Space(15-Len(Trim([EAS ID]))) & "3rd MONTH COMMERCIAL COMMISSIONS".

Could it be possible that my formatting is conflicting with how access is
trying to format the report? If so, how can I resolve this? I am having
trouble exporting all my data format reports to text. The report that don't
have data formatting code, export to text just fine.

I even tried using output to (which I knew would work)
 
Back
Top