proper case in access

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top