[RESOLVED] Help with this conditional statement

[DanielT]

Hello, Help! Got stocked in this...


The textbox must only accepts number so i write this code

Private Sub cmdOK_Change()
If Not IsNumeric(txtnum.Text) Then
MsgBox ("Input a valid number.")
End If
End Sub

_______________________________________________________

But the problem is how could I make the txtnum only accepts
10 digit number's and it will check whether it is number or not.
If it is less than 10 then it will not be accepted.

Let's try putting the code only in the cmdOK


I hope you understand and sorry for my bad english...
Thanks!!!

[dee-u]

You could use the LEN function:

If LEN(txtnum.text) < 10 Then

[DanielT]

Hey dee-u thanks for your reply.

Oh yea why did I forgot this one, it should work now thanks a lot!!!