Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Thanked 0 Times in 0 Posts

    Publishing MS Access 2000 to MS Word (Access 2000)


    Im hoping this forum has the solution to most a likely a simple problem.

    When "Publishing Access 2000 Labels to MS Word" there is a problem when when printing. Though the page set up is the same for the Access labels (Avery) and also the labels in Word (I checked) when printing the labels in the converted Word format the rows shift so that the labels do not fit. What is interesting is that if I print the labels directly from Access there is no problem or if I should print brand news labels directly for MS Word template there is not a problem.

    Any clues to why this is happening would be appreciated.


  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts

    Re: Publishing MS Access 2000 to MS Word (Access 2000)

    Yes - unfortunately, when you publish an Access report to Word, it is converted to Rich Text Format, which doesn't support tables (that's how labels are done in Word). So it attempts to line things up as best it can using tabs and other arcane tricks. You will also loose any graphics, and even lines drawn around text. If you want nice labels printed, you are stuck with either using an Access report, or running a Word mail merge with your Access database as the data source, OR doing some clever things with Automation, which is lots of work.

Posting Permissions

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