Exporting Report to Excel

[NOVAmichelle]

I have a report and when I export to Excel, some of the headings of the columns say "Text43" for example, instead of the names of the fields. I have checked in the properties and all have "Captions" which correctly identify the field.
Is there something i'm missing?

 

[67peshawar294]

If you open the properties sheet of the textbox(s) in question, you will find that the "Name" of the textbox is your "text43" and the "Control source" is the name of the field. Change the "Name" of the txtbox to whatever you need.
jim