Only Text in a text field

[Khalil Handal]

Hi,
I have a text Box for names, How to allow only letters in it ?

I have found this validation rule : Is Null OR Not Like "*[!a-z]*"
This does not work for different languages. If I used Hebrew or Arabic alphabet it does not accept.

So, Is there a way to have a user enter only alphabet for different languages ?



Sincerely yours
Khalil

[Bob Fitz]

Perhaps you could use the IsNumeric() function in the forms BeforeUpdate event but I have no idea of how well it works with the Hebrew or Arabic alphabets.

[pbaldy]

If you intend to exclude "abc123def" because of the numbers, you'd have to test character by character. You could do that during input or in the before update event.

[Khalil Handal]

Hi,
Yes, it should exclude any number like mentioned. It should not have "abc123def".
How it should be done?

Khalil

[pbaldy]

Depends on how you want to do it. You can write a function that you call in the after update event that changes the input to exclude the numbers or use the before update event to warn the user and abort the entry. You can use the keypress event to simply exclude numbers from whatever the user is tying (numbers would simply not register, which could confuse a user, so you could add a message box).