代码如下,有那为大虾可以帮我看看,就是定一个COMMAND控件,如何把所有的DATACOMBO控件的TEXT清空
Dim setcontrol As Control
For Each setcontrol In Me.Controls
If TypeName(setcontrol) = "DataCombo" Then
setcontrol.Text = ""
End If
Next
Exit Sub
Dim setcontrol As Control
For Each setcontrol In Me.Controls
If TypeName(setcontrol) = "DataCombo" Then
setcontrol.Text = ""
End If
Next
Exit Sub
SET SETCONTROL.ROWSOURCE = NOTHING
For Each setcontrol In Me.Controls
If TypeName(setcontrol) = "DataCombo" Then
MsgBox "准备清空" & setcontrol.Name
setcontrol.Text = ""
MsgBox setcontrol.Name & "已清空"
End If
Next