Ignore Blank/Non-Numeric Input On Form???

[JockVSJock]

Created a form and I don't understand how to do the following.

I have a form that has 10 fields and if they DO NOT enter in a number or don't enter anything, it is ignored.

How do I write this in code? I don't want an error messasge either, just ignore blanks and non-numeric entries...See my code below...


If Not IsNumeric(txt1.Text) Or txt1.Text <> &quot;&quot; Then
'what do I put here?
else if
If Not IsNumeric(txt2.Text) Or txt2.Text <> &quot;&quot; Then
'what do I put here?
else if
If Not IsNumeric(txt3.Text) Or txt3.Text_
<> &quot;&quot; Then



Get what I am trying to do?


thanks

 

[rkinrade]

I'm assuming you only want to process numbers?

Dim ctrl as Control
For Each ctrl in Controls
If TypeOf ctrl is TextBox then
If IsNumeric(ctrl.text) Then
'process the information in the Textbox
End If ' if it's not a number it's ignored
End If
Next ctrl