All Textboxs on form set to Null

[DUF]

Hi,
On the On Load event of an form I want all the textboxs to be set to null
I tryed the following code but it will not work maybe someone can tell me what is wrong?

Dim ctl as Control
For Each ctl In Me.Controls
If ctl.Controle type acTextBox Then
ctl = Null
Next ctl

thanks

Duf

 

[JeremyNYC]

If ctl.ControlType = acTextBox Then =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[MazeWorX]

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl = Null
End If
Next ctl Remember amateurs built the ark - professionals built the Titanic