How to Convert Text to Title Case for Movies, Books, and Songs in Microsoft Access, Part 2

In this Microsoft Access tutorial, I will show you how to continue building our title case function by adding logic to handle small words correctly. We will also cover array manipulation, using the DLookup function to validate small words, and correctly formatting titles. This is part 2.

Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will cover delimiters like colons or dashes, Roman numerals, and acronyms. I will show you how to create a table with items that should not be lowercased, thus enhancing the title case function to handle these specific exceptions.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Title case Microsoft Access, convert text title case, movie title formatting, book title formatting, song title formatting, small words capitalization, title case function Access, Access VBA tutorial, Access string functions, dynamic title case function, DLookup Microsoft Access, string handling Access

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Thanks for this very interesting series, Richard! I'll definitely be using the code! "The Wrath of Khan" is good, but I like "The Voyage Home" (because of the Bus scene)" LOL!!!

[Nigelwriter]

Like given, and a virtual bonus Like for acronyms vs initialisms 🎉

[gsr]

Is Access still used? I had years of experience with it but can't find a job doing it anymore.

[fuegoesmeralda]

Somehow I was expecting record sets were going to be used to browse through the table of short words...