在DataGird的RowColChange事件中写 Dim cCol As Column For Each cCol In DataGrid1.Columns '取每列的文本 Debug.Print cCol.Text Next cCol
Dim cCol As Column,sRowText as String For Each cCol In DataGrid1.Columns '取每列的文本 Debug.Print cCol.Text sRowText =sRowText & cCol.Caption & cCol.Text & " " Next cCol Msgbox sRowText
同意wanwenguo private sub dbgrid1_cllick() msgbox dbgrid1.datasource.recordset("字段名1") '.... end sub
Dim cCol As Column
For Each cCol In DataGrid1.Columns
'取每列的文本
Debug.Print cCol.Text
Next cCol
For Each cCol In DataGrid1.Columns
'取每列的文本
Debug.Print cCol.Text
sRowText =sRowText & cCol.Caption & cCol.Text & " "
Next cCol
Msgbox sRowText
private sub dbgrid1_cllick()
msgbox dbgrid1.datasource.recordset("字段名1")
'....
end sub