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.
I also tried this
MSHFlexGrid1.ColWidth(3) = 0
but foud that the user is still able to expand the width of the column.
Please help
