'use the controls collection to cycle through all controls on a form
'if we find a texbox, then clear it. Note that you cannot use the .Clear method this way.

  '---clear all text boxes
        Dim ThisControl As Control
        For Each ThisControl In Controls
            If TypeOf ThisControl Is TextBox Then
                ThisControl.Text = ""
            End If
        Next