proper case in access

G

Guest

Is there a function that will convert my text from ALL CAPS to Proper Case?
I've found some postings with vbProperCase but I don't know vb.
 
G

Guest

You can use StrConv - you might want to start by making a backup of your
database! Then create a SELECT query that includes the field that you wish to
update. Convert this query to an UPDATE query – use the Expression Builder in
the Update row of the grid as follows:

Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)

Note for Uppercase use 1 and lower case use 2 – this actually changes the
case rather than the format property which only changes how text is displayed.
 
G

Guest

Thank you, that worked great. But now I have a follow up. Is there any way
to avoid issues like acronyms going from ABC to Abc? Or ABC LLC going to Abc
Llc?

Sheila D said:
You can use StrConv - you might want to start by making a backup of your
database! Then create a SELECT query that includes the field that you wish to
update. Convert this query to an UPDATE query – use the Expression Builder in
the Update row of the grid as follows:

Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)

Note for Uppercase use 1 and lower case use 2 – this actually changes the
case rather than the format property which only changes how text is displayed.


mktg@wfi said:
Is there a function that will convert my text from ALL CAPS to Proper Case?
I've found some postings with vbProperCase but I don't know vb.
 
G

Guest

Hmmm - can't think of any unless you know what they are and can use criteria
to exclude those from the update? There may be a way using VB but I'm not a
VB person I'm afraid, Sorry

Sheila

mktg@wfi said:
Thank you, that worked great. But now I have a follow up. Is there any way
to avoid issues like acronyms going from ABC to Abc? Or ABC LLC going to Abc
Llc?

Sheila D said:
You can use StrConv - you might want to start by making a backup of your
database! Then create a SELECT query that includes the field that you wish to
update. Convert this query to an UPDATE query – use the Expression Builder in
the Update row of the grid as follows:

Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)

Note for Uppercase use 1 and lower case use 2 – this actually changes the
case rather than the format property which only changes how text is displayed.


mktg@wfi said:
Is there a function that will convert my text from ALL CAPS to Proper Case?
I've found some postings with vbProperCase but I don't know vb.
 
G

Guest

Thanks for the help. This saved me a lot of time.

Matt

Sheila D said:
You can use StrConv - you might want to start by making a backup of your
database! Then create a SELECT query that includes the field that you wish to
update. Convert this query to an UPDATE query – use the Expression Builder in
the Update row of the grid as follows:

Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)

Note for Uppercase use 1 and lower case use 2 – this actually changes the
case rather than the format property which only changes how text is displayed.


mktg@wfi said:
Is there a function that will convert my text from ALL CAPS to Proper Case?
I've found some postings with vbProperCase but I don't know vb.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top