Re: acformattxt vertical spacing issues when opening with MS WORD/NOTE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brian (bcap_at_IHATESPAMclara.co.uk)
Date: 10/17/04 

Date: Sun, 17 Oct 2004 12:40:16 +0100

"Scott" <Scott@discussions.microsoft.com> wrote in message
news:2C986638-D2FA-438B-AEC7-3C969726EBE4@microsoft.com...
> I'm using MS Access 2000 and designing a form that will be send out to a
file
> using:
>
> DoCmd.OutputTo acOutputReport, "Report1", acFormatTXT, "Report1.txt", True
>
> The report output looks good, no strange vertical spacing, etc. The design
> view preview is also right on the money. The problem appears to be in MS
> Word or Notepad. It seems to open the report and spills the first page
onto
> a second. Now if I try to output to acFormatRTF and bring it into MS WORD
or
> MS WORDPAD it looks great.
>
> The bottom line is I'm trying to get a report that can be imported into
just
> about any viewer by making the report a fixed pitch font, using 80 char.
> accross, etc.
>
> Can anyone shed some light on the problem?
>

No, I can't throw any light on your particular problem, but you could search
the web for a great little product called Win2pdf, which allows you to save
anything as a PDF file. It only costs about $30, you can try before you
buy, and I can tell you from my own experience that it works.

OK, a PDF file can't be read by ANY reader, but who cares? Everyone has got
(or can get, for free) Acrobat Reader.

Relevant Pages

  • Re: Embedding PDF file in Report
    ... I have an Access2003 report with an embedded PDF file, ... using an acrobat reader, typically adobe acrobat reader. ...
    (microsoft.public.access.reports)
  • Re: Can a PDF file contain a virus or a spyware?
    ... Can a PDF file contain a virus or a spyware? ... There was a report in 2001 that the full developer version of Acrobat ... The Acrobat Reader was ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Sending Forms or picture of forms
    ... The only realistic approach to make this work is to actually build a report ... out as the PDF file, and then launcher the e-mail client and attach the pdf. ... 'Dim ol As Outlook.Application ...
    (microsoft.public.access.forms)
  • Re: pdf file per record creation from form
    ... ensure that the report will print to the PDF-writing device ... >a report or form to a separate pdf file, ... >> filename by setting a registry key. ... >> document that is printed to the Adobe PDF printer. ...
    (microsoft.public.access.formscoding)
  • RE: How can I store a PDF file in a SQL database?
    ... You should store the file in a image data type. ... Use a BinaryFormatter ... > flat file The PDF file contains the overview of our weekly invoice ... the overview PDF and my detailed report. ...
    (microsoft.public.dotnet.general)