>>>>>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.