让msflexgrid控件的宽度自动调整

2010-02-05 09:51

Public Sub AdjustColWidth(frmCur As Form, gridCur As Object, Optional bNullRow As Boolean = True, Optional dblIncWidth As Double = 0)
'--------------------------------------------------------------------
'功能:
'               自动调整Grid各列列宽为最合适的宽度
'参数:
'               [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 + 100
                          End If
                  Next
          End With

End Sub

本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请点击举报。