Changing Text

[Randy]

Hello....Does anyone know of a way to change text that has been typed in ALL
CAPS to Sentence case without having to retype everything?

 

[Douglas J. Steele]

Permanently, or just for a specific usage?

For a specific usage, use the StrConv with a conversion argument of 3:

SELECT StrConv([MyAllUpperCaseField], 3) FROM MyTable

For a permanent solution, use an Update query which invokes that function.
(Make a backup copy of the table first, just in case something goes wrong!)

 

[tina]

i think the conversion argument 3 equals vbProperCase, not sentence case,
Doug.

Permanently, or just for a specific usage?

For a specific usage, use the StrConv with a conversion argument of 3:

SELECT StrConv([MyAllUpperCaseField], 3) FROM MyTable

For a permanent solution, use an Update query which invokes that function.
(Make a backup copy of the table first, just in case something goes wrong!)

 

[Randy]

Hi Doug...I supose I should make this a permenant thing so users can type
either way. If a user types in lower case will this auto convert to sentence
case? Also, where exactly should I put the recommended statement?
--
Randy Street
Rancho Cucamonga, CA

Permanently, or just for a specific usage?

For a specific usage, use the StrConv with a conversion argument of 3:

SELECT StrConv([MyAllUpperCaseField], 3) FROM MyTable

For a permanent solution, use an Update query which invokes that function.
(Make a backup copy of the table first, just in case something goes wrong!)

 

[Douglas J. Steele]

What I showed you was the SQL for a query. If you build your query through
the graphical builder, you'd drag the field in question into the grid, then
replace the name of the field in the grid with
StrConv([MyAllUpperCaseField], 3)

However, as Tina correctly pointed out, 3 is Proper Case, not Sentence Case.
There isn't actually a way to convert to Sentence Case.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Doug...I supose I should make this a permenant thing so users can type
either way. If a user types in lower case will this auto convert to
sentence
case? Also, where exactly should I put the recommended statement?
--
Randy Street
Rancho Cucamonga, CA

Permanently, or just for a specific usage?

For a specific usage, use the StrConv with a conversion argument of 3:

SELECT StrConv([MyAllUpperCaseField], 3) FROM MyTable

For a permanent solution, use an Update query which invokes that
function.
(Make a backup copy of the table first, just in case something goes
wrong!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello....Does anyone know of a way to change text that has been typed
in
ALL
CAPS to Sentence case without having to retype everything?