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

[getusama]

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

[gavio]

Would this do:

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

?

[getusama]

Thank you so much gavio

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

[gavio]

Or:

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

[gavio]

Thank you so much gavio...

You're welcome