Clearing a form

[armesca]

Is there any way to set all of the text boxes/combo boxes, etc to null values all at once in VB as opposed to clearing each one individually.

 

[michaeljryan78]

If the form is unbound, then you may want to try this:

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acComboBox Or ctl.ControlType = acTextBox Then
ctl.Value = Null
End If
Next ctl