Integer/Text Form Validation...

[ewomack]

What's the best way to validate a txtbox that needs an integer input into it so that it does not allow text or other garbage. In JavaScript there's a handy "NaN" ("Not A Number") function that can be validated against a textbox (if x = NaN Then alert("Booom!")) if a string is input instead of an integer.

I've tried converting the textbox to an integer and if the conversion fails, then obviously it's not a number. This is a bit bulky, though, and I'm hoping there's a slicker way.

Those were long sentences. I hope they made sense.

Thanks,

Ed

[Renee K]

If not IsNumeric(text1.text) then msgbox "Entry must be numeric"

[ewomack]

Thank you! Wow was that easy.

I don't know why I couldn't find something so simple in my texts...

Ah well.

Thanks,

Ed

[Renee K]

I'm glad I could help.