Input Mask

[AccessPhil]

I have field [Last Name] in the table. I want an input mask where the first letter of the field is Uppercase and the succeeding letters is lowercase. Is this possible. Thanks.

 

[jonesy]

Hi Phil, you could try entering something like :

>L<LLLLLLLLLLLLLL

into input mask. This would limit the length of the surname to however many L's you have.

Jonesy

 

[AccessPhil]

Jonesy,


Thank you very much! It works.



AccessPhil

 

[qwkslvr1999]

Another option would be to add an after update event to the lastname control. This way your text(lastname) will not be limited to the number of Ls you have in your input mask.

Put this in lastname after update event:

Private Sub lastname_AfterUpdate()
me.lastname=StrConv(Me.lastname, vbProperCase)
end sub

hope this helps.