MSFlexGrig/MSHFlexGrig

I have a queston regarding MSFlexGrid/MSHFlexGrid and was wondering if anyone can help. I have populated a MSHFlexGrid with a recordset from a database.

I have some code that sorts the grid based upon what column the user has clicked on (this is a read only grid). The problem is that there is a column that store dates in a mm/dd/yyyy format. So I created extra column that stores the date in yyyymmdd format. What I have done is, when the user clicks the date column I sort the grid based on the extra column (the yyyymmdd column).

My question is...
Is there a way to hide certain columns in in the MSHFlexGrid?

I tried this
MSHFlexGrid1.ColIsVisible(3) = True
but got an error.

Please help

[Clunietp]

MSFlexGrid1.ColWidth(Index) = 0

I tried this...
MSHFlexGrid.ColWidth(3) = 0

The problem I had with that the user can still expand the column.

[veryjonny]

sorry about bringing this thread up again,but me too facing the same kind of problem.

I want to hide one of the columns of the Flexgrid - Did you find any soln for it?

Does any one else knows it?

thanks a lot.

[Hack]

I think setting the column width to 0 is the only way. One method you could use to prevent people from permentaly resizing the column would be to set it back to 0 in the MouseUp event. They will resize it using the mouse, but as soon as they release the mouse it will go back to 0 again. Kloogy, yes...