Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    NSW, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 problems exporting Access reports to rtf format (Access97)

    This following could be part of the text in memo field.

    ================================================== ==================================================
    RATIONALE. HAHS and the Hunter Rural Division of General Practice (HRDGP) recognise the need to undertake a stakeholder consultation process and comprehensive needs assessment, to explore the concerns and service access issues of service providers (GP and hospital) and local rural communities. The HAHS will carry out consultations with rural GPs and Hospital Emergency Departments and are currently undertaking a major community consultation exercise across rural Hunter, as part of the development of its strategic direction for rural health services.

    METHODS. This project will conduct a telephone survey with a representative random sample of community members from rural areas in the Hunter serviced by the Hunter Rural Division of General Practice. The information gathered in the community survey will supplement information obtained in the stakeholder consultations and provide the HRDGP and HAHS with a clear indication as to the level of need and support for improved after hours access to health care. This information will be used to guide the development of a business plan for after hours service provision in rural areas of the Hunter

  2. #2
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 2 problems exporting Access reports to rtf format (Access97)

    It is almost impossible to get a good RTF output of an Access report. The RTFdocument does it's best but something is always out-of-whack. Rules disappear, line spacing changes pulling the footers up about an inch or 2, memos get truncated because word-wrap is different but field "height" is fixed, hard returns appear, etc... Which is why Microsoft added the File...Export...Save As...Snapshot and the Snapshot Viewer. It's like a PDF. It retains formatting, unlike RTF export.

    You're probably going to have to compromise somewhere along the line. Microsoft does have a fix for the truncation problem with Memo fields in Access 2000 you can download:

    http://support.microsoft.com/search/previe...b;en-us;Q281153
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 problems exporting Access reports to rtf format (Access97)

    Any Access report that is moderately complex will not cleanly export to RTF.

    I find that a RTF export normally requires extensive manual tweaking before it becomes usable.

    Consider creating your reports in Word (forget the access reports in this case) so you are only performing one set of maintenance. Place bookmarks at the points where you need to insert data, tables etc and populate the reports via VBA. Just move between bookmarks for the data that would normally populate the reports.

    If a section of the word document is not required select between bookmarks (section breaks) and delete.

    Stewart

  4. #4
    Lounger
    Join Date
    Sep 2001
    Location
    NSW, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 problems exporting Access reports to rtf format (Access97)

    I should have made myself clearer. It

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 problems exporting Access reports to rtf format (Access97)

    This issue interested me because I gave up on sending reports to Word - the formatting gets lost, but have been successful in writing them to the PDFWriter. I copied your text into a memo field and created an Access report (although not 600-700 pgs). The text printed in full to the PDFWriter, formatted just as it displayed in the report - lines stayed as lines and did not become paragraphs.

    Does the same thing happen if the report is only a few pages?

Posting Permissions

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