controltype keeps giving method or data member not found

[Chris]

Hope someone can give me the easy answer

Following code keeps giving me the "Method or Data Member not Found"

Private Sub cmdClear_Click()
Dim ctl As Controls

For Each ctl In Me.Controls

If ctl.ControlType = acComboBox Then
ctl = Null
ElseIf ctl.ControlType = acTextBox Then
ctl = Null
Else
End If

Next

End Sub

Am I missing a reference or something.

Thanks
Chris

 

[PC Datasheet]

Drop the "s" in Controls in your Dim statement.

 

[Chris]

And set CTL = Nothing, not null


Chris

-----Original Message-----
Drop the "s" in Controls in your Dim statement.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com





.

 

[Chris]

Thanks. Taking the s off fixed the error message and will change the null to
nothing.
Chris