I am almost too embarassed to post this, but I am stuck and need it fixed.. I have a textbox where the user has to enter a value before I perform the function..I checked for " ", which works if nothing is entered, BUT if the user uses the spacebar my check doesn't work.. I have tried "", IsNumeric, not IsNumeric, VBNullString, but nothing seems to trap it... This is really silly, please humor me... also it is legit to have blanks within the string or to be numeric ..
Thanks

'== check all the characters to see if they are all blanks
Dim i As Integer
Dim length As Integer
Dim CharFound As Boolean
CharFound = False
length = Len(txtValue.Text)

For i = 1 To length
If Mid(txtValue.Text, i) <> " " Then
CharFound = True
Exit For
End If
Next

If CharFound = False Then
MsgBox "Please enter a search value.", vbExclamation, "Find"
Exit Sub
End If