Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exported Report Formating (Access 2003)

    I run a report with the following code:
    <hr> Dim strDocName As String
    strDocName = "prtNotesForBAAITS"
    DoCmd.OutputTo acOutputReport, strDocName, acFormatRTF, _
    "Cocuments and Settings" & fOSUserName & "Desktop" & _
    "Notes for BAAITS.rtf"
    <hr>
    When I preview the report in Access, it looks great. However, when I open the RTF file in, say Word, a few lines always "bleed" into the following page before kicking a new page. It's like, whatever goes in the first page is larger than the page itself, so the "bleeding" occurs. Other than its margins, is there a way to format the output file? Any guidance appreciated. Thanks!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exported Report Formating (Access 2003)

    Export to RTF has been one of the weakest features of Access for a long time. It hasn't been improved since Access 1.0 or 2.0, and it's basically just a dump to a text-only printer. Fiddling with the margins, either in Access or in Word, is necessary. But I'd avoid this feature altogether if possible. Exporting to snapshot format (.snp) or to PDF format provides much better results.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported Report Formating (Access 2003)

    Thanks, Hans. Take care!

  4. #4
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Exported Report Formating (Access 2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Hans' recommendation is dead on. The snapshot produces good results, but the person receiving the report needs Office. I would like to add that I used tools and information from here to create reports in Acrobat, which works great. If you want more info on how to automate the pdf creation see http://www.lebans.com/reporttopdf.htm. A remarkable tool.

    After importing the modules, the code to run/create the pdf file is as simple as
    Dim strPDFPath As String
    Dim stDocName as String
    Sim PdfName as string

    strPDFPath = "Enter Path"
    strPdfName ="PdfFile.pdf"
    stDocName = "ReportName"

    blRet = ConvertReportToPDF(stDocName, , strPDFPath & strPdfName, False, False)

    Ken

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exported Report Formating (Access 2003)

    Users can download and install the free Snapshot Viewer for Microsoft Access. This stand-alone application lets them view and print .snp files even if they don't have Access (or Office).

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported Report Formating (Access 2003)

    Thanks, Ken ... and again to Hans!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •