Ever get tired of having to type in TextBoxName.text = "" every time you want to empty the contents of a textbox?  Well, Here is an eaiser way:

Put this code in a Module

Public Function ClearText(Form)
On Error Resume Next
For Each TextBox In Form
TextBox.text = ""
Next TextBox
End Function

Now, when you want to clear every textbox that is on a form, you can do it with one line oF code!

ClearText (FormNameHere)