If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask in Access
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? |
#2
|
|||
|
|||
"diko via AccessMonster.com" u14372@uwe wrote in news:550b73ba0ef2f@uwe:
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 |
#3
|
|||
|
|||
Input Mask in Access
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. L?????????????????? "diko via AccessMonster.com" wrote: 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? |
#4
|
|||
|
|||
Input Mask in Access
Title case input mask wrote:
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query Where Clause | Charles G via AccessMonster.com | New Users | 5 | September 22nd, 2005 01:15 PM |
input mask | DrEvil | Running & Setting Up Queries | 5 | May 5th, 2005 02:04 PM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
How to use a default value within an input mask | Kathy | Database Design | 1 | September 3rd, 2004 06:35 PM |