Input Mask in Access

  • Thread starter Thread starter diko via AccessMonster.com
  • Start date Start date
D

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?
 
diko via AccessMonster.com said:
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?
Click to expand...


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
 
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.
 
Title said:
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.
Click to expand...

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