Hi
can anyone please tell me what is the function to only allow string values into a text box. I want to apply validation to one of my textboxes on my program to only allow string values and NOT numeric values.
Is there something simular to Isnumeric that only allows numeric values??
Thanks
hi
Isnumeric will still allow numeric input, which you may deny using IsNumeric
a way of blocking input of figures:
Private Sub Text_KeyPress(KeyAscii As Integer)
If InStr("abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQ RSTUVWXYZ" + Chr(8), Chr(KeyAscii)) = 0 Then KeyAscii = 0
End Sub