Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Publish with Word (2000/XP/2003)

    My client wants to create a report that will subsequently be used in a DTP program to publish his product catalogue. I have created a report and sub report (see attached d/[img]/forums/images/smilies/cool.gif[/img] that in Access looks fine. However whenever it is published in Word as an RTF file the fonts sizes change for the paragraph markers. The font sizes used in the report are Arial 9pt for title and 8pt for text. The paragraph markers vary between 9pt, 10.5pt and 13,5pt. Naturally this is throwing off the formatting of the file. Does anyone have any ideas.

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

    Re: Publish with Word (2000/XP/2003)

    The export to RTF feature is notoriously weak. Microsoft basically hasn't updated it since the earliest versions of Access. Would it be possible to use PDF format instead of RTF? Apart from the "official" and expensive Adobe application, there are free/cheap PDF converters. PDF format is more or less guaranteed to look the same everywhere.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Publish with Word (2000/XP/2003)

    The problem is that there is a fair amound of additional work needed to finalise the document for publication - the addition of alternating footers, additional pages front and back, the inclusion of an index, TOC, etc.

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

    Re: Publish with Word (2000/XP/2003)

    I don't think you can do much about the export to RTF. Perhaps it would be possible to create a macro in Word that cleans up the resulting document and adds some or all of the other features.

    Another possibility would be to create the entire document in Word, either as a mail merge (but the subreport complicates that), or using Automation (controlling Word from Access in code). My fellow moderator WendellB has tutorials on both mail merge and automation on his website:
    Managing Merges with Access
    Automation 101

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Publish with Word (2000/XP/2003)

    Many thanks Hans. Given the timing we are going to have go with what we have got and to do a lot of rework in MS Word or Publisher. Even this has saved a lot of effort. Maybe for next year's catalogue I can figure a better way.

    Regards

    Peter

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Publish with Word (2000/XP/2003)

    I don't know whether this is any help, but when I tried exporting your report to RTF using Word 2003 and Access 2003, it preserved your font settings exactly the way they were in the report.

    What version are you using? All three?

    I don't like the way the subreport gets put in with tabs, but if you are not going to modify the actual text or layout I don't suppose this matters. But if you touched the text at all this stuff could go all over the place.
    Regards
    John



Posting Permissions

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