Returns or sets the sorting order for each column (for use with the Sort property).
Syntax
[form!]VSFlexGrid.ColSort(Col As Long)[ = SortSettings ]
Remarks
This property allows you to specify different sorting orders for each column on the grid. The most common settings for this property are flexSortGenericAscending and flexSortGenericDescending. For a complete list of possible settings, see the Sort property.
To perform the sort using the settings assigned to each column, set the Sort property to flexSortUseColSort.
To sort dates, set the column's ColDataType property to flexDTDate.
For example, the following code sorts the grid so that the first row is in ascending order, the second is ignored, and the third is in descending order:
Private Sub Form_Load()
fg.Cols = 4
fg.ColSort(1) = flexSortGenericAscending
fg.ColSort(2) = flexSortNone
fg.ColSort(3) = flexSortGenericDescending
End Sub
Private Sub Command1_Click()
fg.Select 1, 1, 1, 3
fg.Sort = flexSortUseColSort
End Sub
Data Type
SortSettings (Enumeration)