Return Column Header Text on Right Click of listbox

[Pauldohert]

How do I return the Column Header Text on Right Click of listbox?


Thanks

 

[supercharge]

Is your listbox based on a query, table, ...?

 

[Pauldohert]

Its based upon a query.

 

[Smart]

if you select the combox and look at the properties on the format tab set column heads to yes.

now when you click on the combo box the column headings will appear

 

[Pauldohert]

Thanks - what I want though is to be able to tell which column I mouse click in and to return the column header.

I have the column headers showing - just need to recognise which column I click in. (I probably didn't explain that very well)

 

[supercharge]

IMO,

You can only accomplish that programmatically. There's no such setting in its property for something like that.

A multiple-column listbox only returns its bound-column's value and in turn only is able to give you the header of that column programmatically by using an if-then statement to check for the value for the column and return the appropriate header. (Correct me if I'm wrong )

For something like what you want, neither listboxes nor comboboxes will work. Some controls like FlexGrid or HFlexGrid will do the trick as they allow use to select a single cell instead.