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]

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])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"EllenM" <Ell...@discussions.microsoft.com> wrote in message
news:FCF75E31-90B9-441B...@microsoft.com...

[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.

[24hr...@gmail.com]

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