Hi Bruce,


>That's not a bad idea...we just decided to make every column in every grid sortable, even though a few don't make incredible sense to sort on...but it's consistent, that was our goal...
>
>This is one of those areas where there really isn't much GUI standard, so anything that has good aesthetics and functionality is fine...

When we add our columns at runtime we look if the expression we build the control source from also has an index, ie. If the field is lcField we search through the table for an index expression 'LOWER('+lcField+')' as well as upper. Than to sort its just an ORDER BY ... with the standard toggle asc/desc. Than we change the ForeColor to a user preference.

This does present problems however, when we add a column that has multiple fields. The controlsource is built as alltrim(lcF1)+alltrim(lcF2) but the index expression is lcF1+lcF2, thus not found an automatically denoted as an index.