Only allow letters in textbox for MS Access

Viewed 5102

I have a text box in a form in MS Access. I just want users to enter Letters and spaces. No special characters.

I have implemented the following on KeyPress Event. I am wondering is there any better way to implement the same.

Private Sub txtName_KeyPress(KeyAscii As Integer)
If KeyAscii <> 8 And KeyAscii <> 32 Then  'Not Backspace (important for error correction) and not a Space
    If (KeyAscii < 65 Or KeyAscii > 90) And (KeyAscii < 97 Or KeyAscii > 122) Then   'Allowing lower and upper case
    Beep 'Let the user know they hit an illegal key
    KeyAscii = 0 'Don't let the keystroke through
    End If
End If
End Sub
2 Answers
Related