Help with access report

[ahau]

Hi,

I was wondering if anyone might be able to help me here. I have a form that has a button called export to excel. I have tried to export report to excel and it works. However, i've been asked to produce an excel file that looks like that in the report in the access.

Because in the report, it looks more fancy. it's got columns, headings and things like that. It looks more professional in the report.

I'm not sure if this is a can-do.

Thank you very much in advance

 

[ahau]

Hi,

I haven't got any replies yet. don't know if this is possible to do. The reason for this is i can quickly make the changes on the figure or numbers that's on the report with excel.

Has anyone attempted to export access report to excel and it looks similar to the way how the report is set up such as headings on excel?

Your help is greatly appreciated.

Thank you

 

[belovedcej]

To my knowledge, no. When exporting to excel the information just gets dumped in without formating.

If you want to maintain formating but still allow editing, try out the export to Word (.RTF Format). You will lose boxes, lines, and shading, but all the fonts and coumns will be the same.

Another option is to export the actual query (after formatting) to Word. That will maintain some of the shading and I think it may maintain the lines, too.