Exporting Access 2007 report with columns to Word doesn't allow for accurate cutting/pasting.

Posted on 2011-05-11
Last Modified: 2012-05-11
I am exporting an Access 2007 report to Word using the following command:
DoCmd.OutputTo acOutputReport, "rptList1", acformatRTF, "List1,rtf", True

The export is carried out without any problems, but since the exported report contains columns, it is not possible to cut/paste data from the column without the cut/paste taking the enire row of data associated with the column data selected.

Is there a way to export the columns to Word and to be able to access all of the text freely.
Here is a visual of what is happening. IThis is what my report looks like after it has been exported to Word:

Column1             Column 2              Col umn3
aaaa1                 aaaa2                   aaaa3
bbbb1                 bbbb2                   bbbb3
cccc1                 cccc2                   cccc3

If I attempt to cut the last 2 rows in column3, for example, to retrieve the bbbb3 and cccc3, highlighting the bbb3 and ccc3 will actually highlight and cut bbbb3, cccc1, cccc2, and cccc3.

Is there a way to get around this?

Question by:newbie46
    LVL 13

    Accepted Solution

    Try holding ALT then highlight the area you want to copy, then do your pasting.

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now