Change upper case to sentence case

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
 
F

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

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

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

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?
 

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