MSHFlexGrid Column Width?

[rukk]

How to fix the Column width in MSHFlex grid?

 

[gol4]

something like this what you looking for ?

MSHFlexGrid1.ColWidth(0) = 0
MSHFlexGrid1.ColWidth(1)=MSHFlexGrid1.width * .10 ' means 10 % of grid
MSHFlexGrid1.ColWidth(2)=MSHFlexGrid1.width * .20 ' means 20 % of grid
MSHFlexGrid1.ColWidth(3)=MSHFlexGrid1.width * .30 ' means 30 % of grid
MSHFlexGrid1.ColWidth(4)=MSHFlexGrid1.width * .38 ' means 38 % of grid

will need to put each time grid is loaded

 

[rukk]

Thats a good example, but i don't know how many fields will be each time when it opens. Because the fields will vary like one time there can be 10 fields but next time there can be 50. So how to fix it with specific field number.

 

[gol4]

something kind of like this.

For x= 0 to rst.fields.count-1
MSHFlexGrid1.ColWidth(x)=MSHFlexGrid1.width / rst.fields.count
next x

But bear in mind if you have 50 fields the columns will get very narrow so would be best to limit the fields returned.