Checking for valid characters

[Brad]

Is there an easy way to take an input string and check for valid characters?
For instance, I am working on an expense report in where the cells have to
have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to
this fact.

Thanks for the information.

Brad

[Larry Serflaten]

"Brad" <al*******@sbcglobal.net> wrote

Is there an easy way to take an input string and check for valid characters?
For instance, I am working on an expense report in where the cells have to
have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to
this fact.

Perhaps something like:

If strUserText Like "*[!0-9]*" Then
' Bad input
Else
' Good input
End If

LFS

[Brad]

Larry,

Thanks for the information. VB .Net has been a "learn as I go" process.

Brad

"Larry Serflaten" <se*******@usinternet.com> wrote in message
news:OP**************@tk2msftngp13.phx.gbl...

"Brad" <al*******@sbcglobal.net> wrote

Is there an easy way to take an input string and check for valid characters? For instance, I am working on an expense report in where the cells have to have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to this fact.

Perhaps something like:

If strUserText Like "*[!0-9]*" Then
' Bad input
Else
' Good input
End If

LFS