Change upper case to sentence case

[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

 

[fredg]

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

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])

 

[Allen Browne]

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.

 

[EllenM]

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.

 

[24hraxis]

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.

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