| | |
|
|
|
Uppercase in Text box |
|---|
| message from San on 2 Jun 2004 |
I want to capitalize the first character of every word
that I type in a text box. Is there a property setting
this is capital
then that should change to :
This Is Capital
Thanks,
San
|
| fredg replied to San on 02 Jun 2004 |
No, there is no property setting to set.
You are using a form for this data entry, aren't you?
Let the user enter the data into the form control how ever they wish.
Code the Controls AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)
Note that this will not work properly with text like McDaniel,
O'Leary, van den Berg, IBM, NASA, etc., that require 2 or more
capitals or a lower case letter name. You can use a table of
exceptions, but even then, some people write their name as McDaniel
and others as Mcdaniel.
|
|
Archived message: Uppercase in Text box (Microsoft Access)
