Input Mask in Access

[diko via AccessMonster.com]

I would like to help to the following problem:

HOW CAN I CREATE AN INPUT MASK IN A FIELD OF AN ACCESS TABLE, IN ORDER TO
HAVE ONLY THE FIRST LETTER CAPITAL AND THE OTHER CHARACTES LOWER?

 

[Tim Ferguson]

How can i create an input mask in a field of an access table, in
order to have only the first letter capital and the other charactes
lower?

Input masks are really nasty things to impose on your users. Better by far
to use the LostFocus event to change the case.

Look up help on StrConv() function.

Bear in mind that if this is for names, then you are going to get badly
stuck with people called O'Shaunessy, Van Druid, te Water Naude, etc. You
may be better of with better trained users.

Hope that helps


Tim F

 

[Guest]

You can use the following input mask to do this...BUT I haven't been able to
figure out how to Title Case double word entries such as New York. With this
input mask, it turns out as New york.

 

[Rick Brandt]

You can use the following input mask to do this...BUT I haven't been
able to figure out how to Title Case double word entries such as New
York. With this input mask, it turns out as New york.

This cannot be accomplished with an InputMask. Use code in the AfterUpdate
event.