gridhead = "" & Chr(9) & "规格" & Chr(9) & "品牌" & Chr(9) & "花纹" & Chr(9) & "数量" & Chr(9) & "单价" & Chr(9) & "总金额" & Chr(9) & "类别" & Chr(9) & "厂名"
Grid.AddItem gridhead
Dim rs As DAO.Recordset
Set rs = Pub_db.OpenRecordset(strsql)
While Not rs.EOF
Grid.AddItem "" & Chr(9) & rs!gg & Chr(9) & rs!sb & Chr(9) & rs!hw & Chr(9) & rs!sl & Chr(9) & rs!dj & Chr(9) & rs!zje & Chr(9) & rs!lb & Chr(9) & rs!cm
rs.MoveNext
Wend
--------------
这样,显示的时候多出一行空白行,如果继续刷新的话,又多出与现有记录数相同数量的空白行,不知什么问题?
Grid.AddItem gridhead
Dim rs As DAO.Recordset
Set rs = Pub_db.OpenRecordset(strsql)
While Not rs.EOF
Grid.AddItem "" & Chr(9) & rs!gg & Chr(9) & rs!sb & Chr(9) & rs!hw & Chr(9) & rs!sl & Chr(9) & rs!dj & Chr(9) & rs!zje & Chr(9) & rs!lb & Chr(9) & rs!cm
rs.MoveNext
Wend
--------------
这样,显示的时候多出一行空白行,如果继续刷新的话,又多出与现有记录数相同数量的空白行,不知什么问题?
grid.row=1
Grid.Row = Grid.FixedRows
Grid.Cols = 8
--------------------
之前我已经加入了这些,第一行还是空白行,从第二行开始才是标题行.
我用的是msflexgrid,不是mshflexgrid
加上这句:msflexgrid.rows=1