Change upper case to sentence case

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
The names of my church's ushers are all in upper case in the table. How can
I have them appear in title case in the report?

Thanks in advance,
Ellen
 
Hello,
The names of my church's ushers are all in upper case in the table. How can
I have them appear in title case in the report?

Thanks in advance,
Ellen
Click to expand...

Just for display?
=StrConv([UsherName])

Unfortunately, this will improperly capitalize some names that ought
to have more than one capital, McDonald, O'Brien, Smith-Jones, etc.
and also improperly capitalize some names that ought not be
capitalized, van den Steen.
A work around could be a table of exceptions that can be 'DLookUp'ed
and a choice of spelling offered.


Permanently?
Run an Update Query.
Update YourTable Set YourTable.UsherName = StrConv([UsherName])
 
Assuming your field is named FullName, set the Control Source of the text
box on your report to:
= StrConv([FullName], 3)

Change the text box's Name property as well: Access gets confused if a
control has the same name as a field, but is bound to somthing else.

You will probably find this doesn't work very well, e.g McDonald may not be
happy.
 
Thanks so much!!! It worked even though the name was a concatenation,
namely, "=StrConv([First Name] & " " & [Middle Initial] & " " & [Last
Name],3)". Sounds like I need to convert them in an update query so I can
handle the names like McDonald individually.
 
Thanks so much!!! It worked even though the name was a concatenation,
namely, "=StrConv([First Name] & " " & [Middle Initial] & " " & [Last
Name],3)". Sounds like I need to convert them in an update query so I can
handle the names like McDonald individually.
Click to expand...

Hey, I have a question about this. Where did you put the code?
 
Back
Top