Clear Values from All Controls on Form

gmayor · #1 03-29-2019, 03:04 AM

Presumably you have other controls on the form such as the control button that cause the error. You could use an alternative approach e.g.

Code:

Private Sub cmdClear_Click()
Dim cControl As Control
    For Each cControl In Me.Controls
        Select Case TypeName(cControl)
            Case Is = "TextBox", "ComboBox"
                cControl = vbNullString
            Case Else
        End Select
    Next
End Sub

ScottyBee · #2 04-02-2019, 09:55 AM

Thanks gmayor, your code works great. Is interesting how easy it is for one to get caught up in the complexity of the code that we miss the simple things. Thanks again, I really appreciate it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Form to Save as and clear	sfitzsimmons	Word VBA	1	01-11-2019 02:03 PM
Don't clear form fields when protecting as a form	BruceM	Word	5	10-06-2016 08:26 AM
Form with content controls - expands but at the bottom of the form	louiseword	Word	3	05-27-2016 12:47 AM
Retrieve Values from Content Controls for hidden	john s.	Word VBA	1	02-21-2014 02:14 PM
Calculations using values from date picker controls	Inkarnate	Word	0	06-09-2010 07:16 AM