Set DataGrid1.DataSource = RSKC '记录不是只读
Dim I As Integer
Dim J As Integer
If RSKC.RecordCount > 0 Then
For I = 1 To RSKC.RecordCount
DataGrid1.Row = I - 1 '当I=2时,运行到此提示数据类型不对
For J = 3 To 5
DataGrid1.Columns(J).Text = IIf(Val(DataGrid1.Columns(J).Value) = 0, "", DataGrid1.Columns(J).Value)
Next J
Next I
End If
Dim I As Integer
Dim J As Integer
If RSKC.RecordCount > 0 Then
For I = 1 To RSKC.RecordCount
DataGrid1.Row = I - 1 '当I=2时,运行到此提示数据类型不对
For J = 3 To 5
DataGrid1.Columns(J).Text = IIf(Val(DataGrid1.Columns(J).Value) = 0, "", DataGrid1.Columns(J).Value)
Next J
Next I
End If
value=0
displayvalue=""
生成记录集后,不想在datagrid表格中显示0的值,所以想用循环去掉的是0的值。