I don't know what is standard, but in my experience, a single click on a grid header sorts the table on the column in ascending order. If the table is already sorted on that column then it does the same sort in descending order. You can check order() for the current index.
>We have a customized grid class. In this class, a single click on a column header sorts the record source on that column. You can also click on a column heading and drag the column to another position on the grid. This action causes the sort to be performed. My questions
>
>1. Is it standard practice to have the single click perform the sort or is it more common to use a double-click?
>
>2. Assuming that I leave the sorting code in the Click method, is there any way to capture the fact that the column order has changed and then bypass the sorting code?
>
>3. Moving a column does not appear to change it's location in the grid.columns() array. For example. I pick up column 7 and move it to be column 5. The active column is now column 5 but a reference to
grid.column(activecolumn).controlsource point the
original column 5. Is there a simple way to re-order the reference in the grid.columns() array?
>
>Thanks to all........Rich
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"