Link to home
Start Free TrialLog in
Avatar of newbie46
newbie46

asked on

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

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?

thanks.
ASKER CERTIFIED SOLUTION
Avatar of Lucas
Lucas
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of newbie46
newbie46

ASKER

Perfect!!