Exporting a report to Excel and/or Word

P

PJ

I have a current report that when I export to excel or word the current
formatting is not the same as the report. Is there anything I can do to
correct that?

Thanks in advance
 
N

NetworkTrade

if you are more interested in excel - you can consider exporting the
underlying query/table rather than exporting the report (in 07 exporting a
Report to Excel is no longer available)

as to going to Word - I've never had a problem in going from Report to Word
so not sure why that is changing....
 
J

JohnB

I have the same problem with Word. I carefully get my Access line to contain
exactly the same number of letters as my word document, and ensure fonts and
margins on both Access and Word are the same. Still sometimes I get
difference in formatting. I suspect its because we use proportional fonts,
and while I might measure in "w, h,k" (the wide lettes) in actual usage I use
"i,l" (narrow) and this might affect the spacing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I export a report to Excel in Access 2007 1
Export or Import to Excel and Format 4
Export to XML - error 31532 0
Export Access Report to Excel 4
Exporting to Excel 2007 1
Export Data from Report or Query to Excel 1
Keeping format when exporting to excel 1
Can't Export Report to Excel 3

Top