How to export a report to Excel with formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

when I export a report to Excel/Word it does not takes the formats and a
picture that is in the report. How can I make it appear in Excel and or Word
as it is shown in Access when the report is generated?

Thanks!
 
I don't think you can. Neither support all the items you can do in a
report. RTF will not carry over some lines, checkmarks, etc. The Excel
format is really used if you want to play with the data, not so much for the
format. You can modify the report to remove the items not supported by
these formats and then adjust the report design to look better.

If the format is important, you can save it as a pdf file using a
third-party pdf writer, or you can save it as a snapshot format using
Microsoft's snapshot format.

Which option you will choose all depends on what you are trying to
accomplish.

Rick B
 
Back
Top