Mixed case input mask

[John]

Hi

What would be the input mask for a name field where first letter is caps and
the rest lower? Its ideal if the mask can handle multiple names separated by
a space but if not a single word will do.

Thanks

Regards

 

[tina]

i don't think you can do that with an Input Mask. but you can add a line of
code to the form control's AfterUpdate event to achieve the same end, as

Screen.ActiveControl = StrConv(Screen.ActiveControl, vbProperCase)

hth

 

[Tom Wickerath]

Hi John,

Although not based on an input mask, you might want to try the example in this KB article:
http://support.microsoft.com/?id=253911

Its ideal if the mask can handle multiple names separated
by a space but if not a single word will do.

I'm not sure why you state that this would be ideal. It is rarely a good idea to have multi-part
fields. This violates good database design.

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf


Tom

_______________________________________


Hi

What would be the input mask for a name field where first letter is caps and
the rest lower? Its ideal if the mask can handle multiple names separated by
a space but if not a single word will do.

Thanks

Regards

 

[Steve Schapel]

John,

This can't be done with an input mask. However, you can put code on the
After Update event property of the control on the form, like this...
Me.NameOfControl = StrConv(Me.NameOfControl, 3)