How to reset multiple text box in a form 1

[cctrinh]

Hello,

Can someone give me some help to reset multiple text box in a form. I know you can use the following code to reset one box but not multiple boxes. Are there any build in function to handle multiple text box.

me.textbox1=""

Thank for the help.

 

[jflachman]

Try this:
[tt]
Dim ctlTemp as Control
For Each ctlTemp in Me.Controls
If ctlTemp.ControlType = acTextBox Then
ctlTemp.Value=""
End If
Next ctlTemp[/tt] Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[cctrinh]

Thank you very much. It works perfectly. Nice work.

Calvin