Full Version: exporting report to excel- headings not exporting properly
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
greenlizard
What I have is a report that contains a list with headings. When I export this to excel the spreadsheet contains the name of the textboxes (eg textbox1, textbox2, etc...). What I want to export is the value in those textboxes- which changes depending on selections made in a preceding form. The actual list of numbers following the headings IS transferred correctly. Also, don't know if it matters at all but the column headings are in the Page Header section. The list of numbers (that does transfer correctly are contained in the Detail section.

Thanks for the help!

Steve
PolarOrbit
You might try exporting the record source query instead of the report.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.