Column headings when exporting to Excel

[Guest]

When I export an Access report to Excel, the column headings are the control
names in the report detail section. For example, txtDueDate. I can change
the control name to Due Date, but would prefer having standard names in the
associated VBA. For example, I prefer Me.txtDue Date over Me.[Due Date].

I tried entering the desired column heading in the Tag property of the
control, but with no effect.

Is there any way to get the desired headings to both formats without
changing the control names with the associated code changes?

Thanks,

John

 

[Allen Browne]

John, is there any way you could export a query instead of a report?

That would make it easy to alias the fields in whatever way you wish.

It would also mean that your database won't break if you ever open it in
Access 2007. The new version can export tables and queries to Excel, but the
functionality to export reports has been removed.

 

[Guest]

Allen,

Thanks very much for the tip. I should be able to do that. Also, thanks
for the heads up on the feature being removed from Access 2007. Will the
report export to rtf files also be removed?

John

John, is there any way you could export a query instead of a report?

That would make it easy to alias the fields in whatever way you wish.

It would also mean that your database won't break if you ever open it in
Access 2007. The new version can export tables and queries to Excel, but the
functionality to export reports has been removed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

When I export an Access report to Excel, the column headings are the
control
names in the report detail section. For example, txtDueDate. I can
change
the control name to Due Date, but would prefer having standard names in
the
associated VBA. For example, I prefer Me.txtDue Date over Me.[Due Date].

I tried entering the desired column heading in the Tag property of the
control, but with no effect.

Is there any way to get the desired headings to both formats without
changing the control names with the associated code changes?

Thanks,

John

 

[Allen Browne]

Access 2007 still exports reports to RTF (Word), Text, XML, and HTML

With a (free) download from Microsoft if also exports in PDF and XPS also.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen,

Thanks very much for the tip. I should be able to do that. Also, thanks
for the heads up on the feature being removed from Access 2007. Will the
report export to rtf files also be removed?

John

John, is there any way you could export a query instead of a report?

That would make it easy to alias the fields in whatever way you wish.

It would also mean that your database won't break if you ever open it in
Access 2007. The new version can export tables and queries to Excel, but
the
functionality to export reports has been removed.

When I export an Access report to Excel, the column headings are the
control
names in the report detail section. For example, txtDueDate. I can
change
the control name to Due Date, but would prefer having standard names in
the
associated VBA. For example, I prefer Me.txtDue Date over Me.[Due
Date].

I tried entering the desired column heading in the Tag property of the
control, but with no effect.

Is there any way to get the desired headings to both formats without
changing the control names with the associated code changes?