Uppercase in Text box

  • Thread starter Thread starter San
  • Start date Start date
S

San

I want to capitalize the first character of every word
that I type in a text box. Is there a property setting
that I can set?
Example : if I type :
this is capital

then that should change to :
This Is Capital


Thanks,
San
 
I want to capitalize the first character of every word
that I type in a text box. Is there a property setting
that I can set?
Example : if I type :
this is capital

then that should change to :
This Is Capital

Thanks,
San
Click to expand...


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.
 
Back
Top