Share via

Access Report wont Export or 'Copy and Paste' in proper format

Anonymous
2013-03-29T09:08:58+00:00

I am running Windows 7 Enterprise Edition with Office 2010.

I have a large database in Access and several Report Forms that I use to generate daily reports.

The Report displays perfectly in Access, but I need to capture that data to include in other documents (using Excel, Word, and PowerPoint).

Selecting the data on the Report Display screen and 'Copy/Pasting' the data works, but several columns in the report actually change position.

Exporting the data to Excel has the same issue (but actually results in different columns being swapped).

Exporting as a text file outputs the text perfectly (just as displayed in the report), but then I lose all formating.

Is there any way to export a report just as it is displayed?  I need the data, not a pretty picture, so a PDF wont work.

Thanks for your help.

Dan

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-11-01T23:41:16+00:00

    Open your report in Design View.  Right click any one of the "columns" in the report that you want to copy and select Properties.  Select the "Other" tab and notice the Tab Index and Tab Stop properties.  The Tab Index seems to determine the order in which the columns will be copied.  I have Tab Stop set to Yes.  I haven't had the time to check whether or not this matters.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-03-29T14:07:03+00:00

    Exporting the data to excel should follow the column order of the underlying query. I think if you change the field order in the query to match your report you will get the column order you desire.

    0 comments
  3. Anonymous
    2013-03-29T13:52:38+00:00

    I'm surprised that column width/position are your only problems.  An Access report is a graphics image with no text charcters, just graphics that look like characters, lines and other stuff.  Copy/Paste can not possible deal with all that.  Even exporting a report can be so problematic that the feature has been dropped from the last couple of versions of Access.  Instead, you should export the data directly from the table or, more useful, via the report's record source query.

    About the only way to get the exact image of a report is on paper or to output it as a PDF file.

    0 comments