RE: Problem With Report Export to Text File

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What I have done in the past is to set the fonts in the detail section to
quite small (try 6 or 7 point). Set the text boxes and detail height as small
as possible and don't allow them to grow. Then try your export to text.

--
Duane Hookom
Microsoft Access MVP


"ItNeverWorks1stTime" wrote:

I have created a report that needs to be exported to a Text File.

Everything looks good on screen and when the report is printed as an Access
report, but when I export to a Text File extra line breaks are inserted after
every 2nd or 3rd line of the Detail section.

In trying to resolve the problem, I have stripped down the complexity of the
detail to a simple Unbound Text Box containing a single 4digit element and
still the output to a Text File inserts extra linebreaks after 2 or 3 lines.

If I increase the Height of the Detail section from the minimum (which is
what I require) I get more lines appear on the Text File, perhaps 7 or 8
before an erroneous extra line is inserted.

Any ideas, it has been frustrating me for days trying to resolve this problem.
.

Relevant Pages

  • RE: Comparison Report based on a query of only calculations.
    ... Dave Hargis, Microsoft Access MVP ... "Amy Schmid" wrote: ... Client number Client Name Avg # of Cows Production Livestock ... And you want them to appear on the report like: ...
    (microsoft.public.access.reports)
  • Re: In a report -Using a calculated field in Select Case causes Er
    ... Dave Hargis, Microsoft Access MVP ... "Maverick" wrote: ... should open on its own and suspend execution of the report. ... The line has not executed, but it will be the next to execute. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report parameters
    ... Microsoft Access MVP ... and you'll never work a day in your life." ... and make sure you use cboEmpID value in your Open Report ...
    (microsoft.public.access.reports)
  • Re: searching a table using multiple criteria
    ... Dave Hargis, Microsoft Access MVP ... should be the name of a control in your report. ... The code should be in the control source of a control on the form. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Modifying reports with VB6
    ... that you cannot use the runtime to open a report in design view, ... Dave Hargis, Microsoft Access MVP ... Dim strDevModeExtra As String ... possible, if you have it, to install a run time version of ...
    (microsoft.public.access.reports)