Copy the headerrow in a listbox to clipboard

[Sck]

I have a listbox that displays values based on several queries selected by the user. I have code to pull the selected rows (all columns) to the clipboard but I can't figure out a way to pull the column headers. I have the column heads set to YES because it varies depending on the query results.



is there a way to do this in Access 2007 VBA?

Thanks

[June7]

Never seen this. Want to provide code for analysis?

[Sck]

Simple code to get the data out of the listbox as a string:

ColCount = Me.lstDetails.ColumnCount

For Y = 0 To Me.lstDetails.ListCount
If Me.lstDetails.Selected(Y) = True Then
For X = 0 To ColCount
str = str & Me.lstDetails.Column(X, Y) & vbTab
Next
str = str & vbCrLf
End If
Next

The str is then sent to the clipboard. What I can't get is the column heads. The column heads change based on the queries that are selected. I could hard code the column heads but it would be a pain and I would think I could do it via a control property (like .ColumnHeaders in vb)

FIGURED IT OUT:
Checking to see if the row was selected was keeping the header from being copied. It is just a row in the list but it can't be selected. I added a step to copy row 0 every time and now it is working.