Datasheet view Column Header

[Kenln]

Is there anyway to detect a click on a Column Header in Datasheet view.

I would like to sort based on clicking the column header.

Thank you in advance.

 

[Bodisathva]

I would like to sort based on clicking the column header.

highlight the column and press the sort A-Z or sort Z-A button

 

[Kenln]

Oops, I should also have said...

I turn off the menu bars. I wish to sort via code, which I can do. But I don't know the event, if there is one, that triggers when one clicks on the Column Header.

 

[Bodisathva]

But I don't know the event, if there is one, that triggers when one clicks on the Column Header.

Form_MouseDown is triggered anytime the user clicks anywhere on the form

 

[Kenln]

Will this tell me which column header was clicked?

 

[Bodisathva]

Will this tell me which column header was clicked?

it will pass you the coordinates of the click, so technically if you know the column widths, you can extrapolate the column clicked. I was unable (in my admittedly brief search) to find a way to locate the highlighted column in datasheet view.

 

[Kenln]

Thanks for your help.

I'll keep looking,

 

[twosides]

I have a solution, are you still looking or did you find an answer?
Cheers

 

[The_Doc_Man]

In a form in datasheet view, you can place event code. I believe that the column header counts as a label (not going to swear to that). If that is true, you can do an OnClick event with a label. Open the form in datasheet view and switch to design mode. See if you can select the header. If you can, you have a chance. If not, ...

 

[rockman]

twosides,

I'm looking for your solution to this thread. Can you elaborate?

Thanks,
Jeff

 

[Kenln]

Twosides, yes definately!

Rockman,
I have a Form that displays in DataSheet. I am turning off the menu bars. I would like to have the user click (or double click) the column header an have that column sort.

Right now I solved it by having the user double click on any record in the field to be sorted. But most people try to double click the header which seems more natural.

 

[Oldsoftboss]

Try the attachment here....

http://www.access-programmers.co.uk/forums/showthread.php?t=136493

Dave

 

[neileg]

If you used a continuous form instead of a datasheet, you have all the events in the column label.