I have a database that is used over a multiuser network. I have a hard time getting some of my co-workers to take off the CAP LOCKS when entering data. How can I change to text to capitalize only the first letter in a word, to ensure proper data structure.<br><br>Thanks for the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Capitalization of the first letter in a word 2
- Thread starter ind
- Start date
-
2
- #2
use the StrConv function like such:<br>for one cell in the AfterUpdate property you could use:<br><b><br>Me.Text0.Value = StrConv([Text0], vbProperCase)<br></b><br><br>the second half of the statement is what converts the first letter of every word to Upper Case. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question