[RESOLVED] Run Time error 13 on clearing textboxes

[robbedaya]

While robbedaya's code works, it has more code than is needed (the txt variable is not required).

I know the txt-variable is not deeded but it's easier in design time to write your code (if other properties need to be changed) when you can use the <CTRL>+<SPACE>-menu. That's the only reason i created an extra variabele.

Dim ctrl As Control
    For Each ctrl In Me.Controls
        If TypeOf ctrl Is TextBox Then
            ctrl.Text = vbNullString
        End If
    Next ctrl