M
mark
Hi.
I have a couple of textboxes on a vb form. For these, I need the value
entered to be sure to be numeric.
What's the best way to check for that?
application.isnumber(txtBox.value) returns false... becauese it thinks its
text.
the Val(txtBox.value) function does some checking, but it will tell you that
Val(5a) = 5, etc.
I think one time I did some checking on the len of Val(), as compared to the
original len of the entry, but that probably has holes too.
Please point me toward the simple way.
Thanks.
I have a couple of textboxes on a vb form. For these, I need the value
entered to be sure to be numeric.
What's the best way to check for that?
application.isnumber(txtBox.value) returns false... becauese it thinks its
text.
the Val(txtBox.value) function does some checking, but it will tell you that
Val(5a) = 5, etc.
I think one time I did some checking on the len of Val(), as compared to the
original len of the entry, but that probably has holes too.
Please point me toward the simple way.
Thanks.