Solved
Input Mask, only letters all capital
Posted on 2009-05-05
Hi Guys
I need to validate data entry in a form, let's said fieldNAme
I do not like Input Mask that much, >L????????, because it put those _ and if the user starts typing in the middle it will capture the blank spaces and the begining
Now i am using and After update event to transform the input to upper cases,
Let Me.LastName.Value = VBA.Strings.UCase(VBA.Strings.Trim(Me.LastName.Value))
but i would like to restrict it only to letters, i do not want the user to be able to enter numbers or symbols
PLease comment
thanks