MSHFlexGrid控件列宽自动调整

实现列宽根据内容容量自动调节大小。效果如图:

如果实现这样的效果：自我感觉在模块里添加自动调节的代码，然后在窗体里调用比较方便。

模块代码部分：

<span style="font-size:18px;">Public Sub AdjustColWidth(frmCur As Form, gridCur As Object, Optional bNullRow As Boolean = True, Optional dblIncWidth As Double = 0)
'--------------------------------------------------------------------
'功能:
'       自动调节列宽到最合适
'参数
'       [frmCur].........................................当前工作窗体
'       [gridCur].......................................当前要调整的Grid
'--------------------------------------------------------------------
Dim i, j As Integer
Dim dblWidth As Double
    With gridCur
        For i = 0 To .Cols - 1
            dblWidth = 0
            If .ColWidth(i) <> 0 Then
                For j = 0 To .Rows - 1
                    If frmCur.TextWidth(.TextMatrix(j, i)) > dblWidth Then
                        dblWidth = frmCur.TextWidth(.TextMatrix(j, i))
                    End If
                Next
                .ColWidth(i) = dblWidth + dblIncWidth + 400
            End If
        Next
    End With
 
End Sub</span>

如果哪个窗体用到了此功能，直接写一句代码调用即可。

Call   AdjustColWidth(当前窗体名,当前窗体控件名)