column name

[smk23]

Is there a way to get the name of a column from a listbox?
What I tried was

strColName= Nz(Me.ListBox.Column(3).Name , "")

with no results.
Thanks,
Sam

 

[Douglas J. Steele]

I don't believe so, since list boxes aren't always populated through
recordsets and therefore don't always have associated columns.

 

[Marshall Barton]

Is there a way to get the name of a column from a listbox?
What I tried was

strColName= Nz(Me.ListBox.Column(3).Name , "")

Not sure it's what you want, but if you have ColumnHeads set
to Yes, you can get the column heading by using
Me.ListBox.Column(0,3)