Convert Text to Title Case for Movies, Books, Songs

In this Microsoft Access tutorial, I will show you how to convert text to title case for movies, books, and songs using VBA. We'll cover proper case, the Dlookup and NZ functions, for-next loops, and arrays. By the end, you'll know how to automate the capitalization of titles without manual editing.

Landon from Mount Prospect, Illinois (a Platinum Member) asks: How can I change all the text in my database to have the first letter of each word capitalized, like the titles of movies, books, and songs? I have a list of titles in Microsoft Access, but they are all in lowercase or random cases, and I want to make them look nice. What's the best way to do that without having to manually edit each one?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Change Case
• Intro to VBA
• DLookup
• NZ Function
• For Next Loop
• Arrays
• Split Function

Links

• ByRef v ByVal
• Create Function

Recommended Courses

• Arrays in Access Developer 21

Up Next

• Title Case, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, convert text to title case, Microsoft Access title case, title case movies Access, title case books Access, VBA title case function, Access proper case conversion, string manipulation Access, lowercase to title case Access, automated title case conversion Access, Access query design title case