Please Help!

hassruby

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

Nov 15 '06 #1

albertw

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

Nov 15 '06 #2