>>>Hi All
>>>
>>>If I want to ensure that entry into a field on a form is only A to Z and 0 to 9 and spaces whats the best method.
>>>
>>>TIA
>>>
>>>Happy Thanksgiving to al in the US as well.
>>
>>In Keypress:
>>if !(IsAlpha(chr(nKeyCode)) or isdigit(chr(nKeyCode)) or nKeyCode=32)
>> nodefault
>>endif
>
>Thanks Tore.
>
>Quiet here today. All the yanks are stuffing themselves with turkey etc
You're welcome.
Another more felxible solution is
if !upper(chr(nKeyCode))$"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 "
nodefault
endif