Exporting to excel with controlsource as column name in excel?

P

poojagulati84

Hi,

I am working on MS Access 2003. I have created a dummy report with
labels and textboxes having names lbl1, lbl2, lbl3...and txt1, txt2,
txt3...respectively. I am dynamically changing the report's label
caption and textbox controlsource propperty based on a query.So when I
export the report to Ms Excel, the columns heading are like txt1,
txt2, txt3,...

Can excel column heading be based on label caption instead of textbox
name?? Is there any work around for this? Please help.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Only Labels in the First Column of a Report 2
Label in Multi column report 0
i have to remove textbox name 3
Column headings when exporting to Excel 3
Dynamic Reporting based on Parameterized Crosstab Query 10
Exporting Report To Excel 0
#Name? 1
Text from text box to label caption?? 0

Top