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
|
|||
|
|||
Auto-uppercase first letter of first/last name?
Anyone know mask to do this? I'm a beginner here. Thanks.
|
#2
|
|||
|
|||
Auto-uppercase first letter of first/last name?
One way to do this (although it's not foolproof) is to use StrConv function
in code that is run in the AfterUpdate event of the textbox: Private Sub txtBoxName_AfterUpdate() Me.txtBoxName.Value = StrConv(Me.txtBoxName.Value, vbProperCase) End Sub Note that this will capitalize the first letter of each word, which may not give the right results for nonstandard names: rosemarie will become Rosemarie even if it should be RoseMarie etc. -- Ken Snell MS ACCESS MVP "Lauri" wrote in message ... Anyone know mask to do this? I'm a beginner here. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
auto save, auto backup | poonam | Worksheet Functions | 1 | July 15th, 2004 03:29 PM |
making a combo box open when the first letter is typed | Paul James | Using Forms | 2 | July 12th, 2004 01:18 AM |
summing based on auto filter | Art | General Discussion | 2 | June 13th, 2004 04:19 PM |
Letter to Outlook Contact | JJWCLU | Contacts | 1 | May 26th, 2004 03:53 AM |
Auto paragraph number - then remove auto | Legalbits | General Discussion | 2 | May 17th, 2004 08:11 PM |