CODEWITHSUNDEEP
ms-access
Paul
Paul

Reputation: 777

Change Heading for Access subform when copying and pasting into Excel

I have an Access 2010 form with a subform that is displayed in datasheet view. The users want to be able to select and copy the rows from the subform and when they paste into Excel they want the table header to be the value from the main form. Currently it just uses the name of the subform. Is there a way to set this to something else?

Here is what currently shows up in Excel after I paste the copied grid. What I want to have displayed instead of fsubFYTBSummary is a field from the parent record of the form that invoked the subfrom. Is there a way to set this?

enter image description here

Upvotes: 1

Views: 156

Answers (1)

Andre
Andre

Reputation: 27644

There is no way. The copied name is the name of the source object, not the subform control (that would be changeable).

Actually I'm surprised you see this name in Excel. I only see it when pasting a grid to Word or an Email, where the HTML clipboard format is used. The name is the table caption.

You can use http://freeclipboardviewer.com/ (portable) to see the various formats of clipboard contents.

Upvotes: 0

Related Questions