Setting a field to only accept text characters, not numbers

[USAFA2012]

I'm trying to set up a database for a school project. My instructor loves to go into random fields and type garbage in an input field and see if the system stops him (ie "3401" for the "Name" field).

I've tried 15 different validation rules all based on NOT <0, NOT >0, NOT = 0. Nothing works. I would think just setting the field to "Text" in Design view would do it, but I guess that makes too much sense.

Does anyone know how to do this? This is the last bit of table formatting I have to do before I do the relationships (which I know how to do), add in my records (through forms), set up forms, queries, etc.

HELP A NOOB OUT!!!PLZ!!!!

[pbaldy]

There may be a way to do that at the table level, but the easiest way I can think of would be to use the KeyPress event of the form control used to enter the data. Test the KeyAscii value against the allowable characters, and only let through those you want to allow.

[Stressed]

There may be a way to do that at the table level, but the easiest way I can think of would be to use the KeyPress event of the form control used to enter the data. Test the KeyAscii value against the allowable characters, and only let through those you want to allow.

Here is a snipit that I use.

If KeyAscii = 127 Or KeyAscii = 8 Then
Else
    If KeyAscii < 48 Or KeyAscii > 57 Then KeyAscii = 0
End If