Input Mask

[marystewart78]

Hi Folks,

Trying to set an input mask to Capitalize the first letter of a surname but also to do this for ie MacDonald or O'Brian? How can i do this??

Thanks,

Mary

 

[reclusivemonkey]

Hi,

You cannot do this with an input mask; its too complicated for the InputMask to deal with (it will capitalise ALL the letters, but not specific ones). The only way you can do this is to use VBA. If you search around the forums in the VBA section, or the Code repository, I am pretty sure you will find the code to do just what you want. If not please post back, as I did something along those lines some time ago, I should be able to remember it.