• Home
 · 
• Custom Controls/Forms/Menus
 · 
• Procedure to clear all textboxes in a form

Procedure to clear all textboxes in a form

Procedure to clear all textboxes in a form

Rate Procedure to clear all textboxes in a form

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

' Following code can be put 
' in a basic module

Public Sub ClearTextBoxes(frm As Form)
    Dim c As Control
    For Each c In frm
        If TypeOf c Is TextBox Then c.Text = ""
    Next c
End Sub


' Following is the calling code

ClearTextBoxes Me

' OR
Call ClearTextBoxes(FrmName)