如何显示数据并设置适应列宽 vb6.0+spread7

收藏

如何显示查询返回的记录集数据并设置适应列宽 vb6.0+spread7

lz_xiaohai · lz_xiaohai

MSHFlexGrid1控件我是这样操作的。
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