How to determine if an entry is a character or number

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

DontKnow

hi Guys,

I need a way to determine if an single entry is a character or is a number...

Please helpme!!

Cheers
 
hi Guys,

I need a way to determine if an single entry is a character or is a number...

Please helpme!!

Cheers
Click to expand...

Well, a number *is* a character...

The IsNumeric() function will return TRUE if its string argument is a valid
number: e.g. IsNumeric("345") is True, IsNumeric("a45") is false.

There's a tricky little "gotcha" though: if the argument is a valid number in
the old, old Fortran Floating Point notation, such as "31E5" or "2D30"
(corresponding to 31 * 10^5 or 2 * 10^30) it will be true, though you might
consider these to be text.
 
DontKnow said:
I need a way to determine if an single entry is a character or is a number...
Click to expand...


If Me.textbox Like "[a-z]" Then
' it's a letter
ElseIf Me.textbox Like "[0-9]" Then
' it's a number
Else
' it's something else
End If
 
Thnaks mate!!

Thats exactly what I want, I'll do a string search for the rogue "D" or "E"
using the "instr" function


Many thnaks again!!

cheers,
 
Alternatively:

If Me.textbox Like "*[!0-9]*" Then
' text box contains a non-decimal digit
Else
' text box contains only decimal digits
End If
 
Back
Top