>>>>>>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.
Hi Tore think I may change to an exclusion list as I've justs found that it also prevents tabs backspace and return .