[RESOLVED] Need to find the DATA TYPE of a given input

Can anyone please tell me how can I find the data-type from a text field (value entered by the user)?


This will be a great help

Thanks

Would this do:

VB Code:

If IsNumeric(Text1.Text) Then
    Debug.Print "is numerical"
Else
    Debug.Print "is text"
End If

?

Thank you so much gavio

This should get my problem solved ... i'm gonna try it right now

Or:

VB Code:

If IsNumeric(Text1.Text) Then
    If InStr(1, Text1.Text, ".") Or InStr(1, Text1.Text, ",") Then ', or . - depends on your local settings
        Debug.Print "is floating-point numerical value"
    Else
        Debug.Print "is fixed-point numerical value"
    End If
Else
    Debug.Print "is text"
End If

Quote:

---

Originally Posted by getusama

Thank you so much gavio...

---

You're welcome :wave: