>>>>>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
>
>Good morning. (Well, afternoon in your case). Why is that more flexible?
It's afternoon, 16:30 right now. :-)
By more flexible I mean that you can easily add or subtract from the list of "legal" characters.