Exporting Access form to Excel

[china1383]

Hello Experts,

How can we export a existing form in excel by keeping all formatting intact?

eg: I am trying to export the my designed form to excel.After exporting, I am getting all the form data (columns,etc) in one line. However I need to get exported form data exactly look like input form.

Is it possible using macro or any setting?

Regards,
Jonathan

 

[china1383]

Any quick suggestion or help is highly appreciated as it is fatal issue.

Regards,
Jonathan

 

[jaskew]

Does it have to be Excel? Can you export it to Word? I think based off of Excel being a spreadsheet, that what you're asking may be exceptionally difficult, if not impossible, to do.

 

[boblarson]

There is no way to export a form to Excel and keep the formatting. You would have to export to Excel and then recreate the formatting by formatting using VBA.