Hi,
I have 2000 records where we have 10 fields of capital letter’d text.
I have been asked if it is possible to change this to ‘Title Case’ where only the first letter of each word has a capital letter.
Is this possible with automation?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Change CAPS to Title Case
Do you want to permanently changed the stored values, or just display them in title case?
In either case you can use the StrConv function to convert to Title case. To permanently change them use an Update query. To just display them create a calculated field in a query.
In either case use the expression: StrConv([fieldname],3)
It interesting that so many have difficulty finding that function – it’s been there since Access 2.0. I went for a number of years not needing to do that and when I did finally need it (to convert a list of about 50,000 names entered as all caps), I had to do a web search to find it again.
Hi all,
You could also change the input mask for the field in question.
The input mask would be >L<?????????????? This would capitalize the first letter of each word. It would have to be a text field for this to work.
This solution would fix the problem at the source. All future data entry would be in the proper format which would preclude having to run a function whenever you wanted to see your data in this format. In Access 2007 you can also include an output mask to just output the data in your requested format.
Access will ask you if you want to change all the related values in the table when you add the mask.
If you want to get really fancy – here is a little procedure I wrote (or stole and rewrote to be more accurate) that will hanldle exceptions to just captitalising the first letter of each word.
It handles names like O’Connor, MacDonald or McDonald but also allows you to enter words in a table for specific exceptions like Mackenzie.
It can then also be used on lists other than names like Product codes where you may want to retain XXL or USA
I’ve now uploaded the missing file!
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.