FlexGrid column order

How do you change the order that the columns are displayed?

You need to go through each row and swap the two column values:
<pre>
Public Sub SwapGridCols(grd as MSFlexGrid, COL1 as integer, COL2 as Integer)
Dim i as Integer, temp As String

For i = 1 To grd.Rows - 1
temp = grd.TextMatrix(i, COL1)
grd.TextMatrix(i, COL1) = grd.TextMatrix(i, COL2)
grd.TextMatrix(i, COL2) = temp
Next i
End Sub</pre>

if you are populating the grid from a recordset, you can try changing the select order

I'll be amongst the best any minute now !

What's the select order?

in your sql statement when you do "select field1, field2... from table"

when you use a dbgrid, if you use the function that retrieve the field, it will populate the grid with the column in the same order as your statement (field1, field2...)

I'll be amongst the best any minute now !

Oh, got you. I was still thinking of grid properties.

Worked. Thanks.

my pleasure!

I'll be amongst the best any minute now !