Resetting Values in TextBoxes

[Pankaj Upmanyu]

Hi,
I need to know how to reset values in 40 textboxes in one go. Mind I am using 8 arrays of text boxes. Please help how to validate them for a rage of values. I am a new learner.
Thanks
Pankaj

[hariharanmca]

Hi,
I need to know how to reset values in 40 textboxes in one go. Mind I am using 8 arrays of text boxes. Please help how to validate them for a rage of values. I am a new learner.
Thanks
Pankaj

I think the way you are going is wrong!

Can you explain your problem with detail? (we can point you better).

[pureenhanoi]

Hi,
I need to know how to reset values in 40 textboxes in one go. Mind I am using 8 arrays of text boxes. Please help how to validate them for a rage of values. I am a new learner.
Thanks
Pankaj

this code will reset values of all textboxes in one form.

Private cmdReset_Click()
Dim ctrl As Control
On Error Resume Next
For Each ctrl In Me.Controls
  If TypeName(ctrl) = "TextBox" Then
    ctrl.Text = ""
  End If
Next
End Sub