Title Case

[Guest]

okay, I've seen a lot of posts that tell you how to change the text in a
field to Upper Case. Is there a way to change the Text to Title Case where
the first letter of each work is capitalized only? I've got a table with
over 2000 entries and I'd rather not have to retype everything.

 

[Guest]

hi allan,
StrConv ("hi allan ", 3) = " Hi Allan "


You can use StrConv

examples
StrConv ("allan skyner", 1) would return "ALLAN SKYNER"
StrConv ("ALLAN SKYNER ", 2) would return " allan skyner "
StrConv ("ALLAN SKYNER ", 3) would return " Allan Skyner "

Or, if you had fields 1stnames and 2ndNames with allan skyner
You can concenate them AND convert 1st letter to uppercase
Name: =StrConv([1stname] & ", " & [2ndName], 3)

There are quite a few other methods

Hope this is helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Hi Lori

Try this:

UPDATE YourTable SET YourTable.YourField= StrConv([YourField],3);

okay, I've seen a lot of posts that tell you how to change the text in a
field to Upper Case. Is there a way to change the Text to Title Case where
the first letter of each work is capitalized only? I've got a table with
over 2000 entries and I'd rather not have to retype everything.

 

[Guest]

Hi Lori and Allan

Sorry about that - got the names mixed up

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

hi allan,
StrConv ("hi allan ", 3) = " Hi Allan "


You can use StrConv

examples
StrConv ("allan skyner", 1) would return "ALLAN SKYNER"
StrConv ("ALLAN SKYNER ", 2) would return " allan skyner "
StrConv ("ALLAN SKYNER ", 3) would return " Allan Skyner "

Or, if you had fields 1stnames and 2ndNames with allan skyner
You can concenate them AND convert 1st letter to uppercase
Name: =StrConv([1stname] & ", " & [2ndName], 3)

There are quite a few other methods

Hope this is helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Hi Lori

Try this:

UPDATE YourTable SET YourTable.YourField= StrConv([YourField],3);

okay, I've seen a lot of posts that tell you how to change the text in a
field to Upper Case. Is there a way to change the Text to Title Case where
the first letter of each work is capitalized only? I've got a table with
over 2000 entries and I'd rather not have to retype everything.

 

[Guest]

Obviously we're talking about running this thru an update query. THANKS to
both of you.
--
Lori A. Pong

Hi Lori and Allan

Sorry about that - got the names mixed up

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

hi allan,
StrConv ("hi allan ", 3) = " Hi Allan "


You can use StrConv

examples
StrConv ("allan skyner", 1) would return "ALLAN SKYNER"
StrConv ("ALLAN SKYNER ", 2) would return " allan skyner "
StrConv ("ALLAN SKYNER ", 3) would return " Allan Skyner "

Or, if you had fields 1stnames and 2ndNames with allan skyner
You can concenate them AND convert 1st letter to uppercase
Name: =StrConv([1stname] & ", " & [2ndName], 3)

There are quite a few other methods

Hope this is helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Hi Lori

Try this:

UPDATE YourTable SET YourTable.YourField= StrConv([YourField],3);




:

okay, I've seen a lot of posts that tell you how to change the text in a
field to Upper Case. Is there a way to change the Text to Title Case where
the first letter of each work is capitalized only? I've got a table with
over 2000 entries and I'd rather not have to retype everything.