IsNumeric Function Question!

[tekvb1977]

I have a text box on my form. I like the user to only input an integer number. However if they input multiple numbers separated by commas, I like to display a message.

I am using this:

If IsNumeric (Forms![MainForm]![tbx_VB].Value) = False Then
MsgBox "Please enter a numeric number"
End If

However, when I check the if condition for 789,588
it doesn't hold true. For some reason it's still considering 789,588 as numeric when infact it should be treated as a alpha numeric character and the if condition should hold true.

How to make it work? Any suggestions/ideas. Thanks a bunch in advance.

J

 

[Blorf]

Hi.

Try this:

If Val (Forms![MainForm]![tbx_VB].Value) <> Forms![MainForm]![tbx_VB].Value then

ChaZ



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[ZmrAbdulla]

This VB6 FAQ can be used with Access VBA.
How do I make sure that only numbers are entered into a text box? faq222-45 or faq222-302

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.