Convert Text to Title Case in for Movies, etc. 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.

Members

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.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  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

• Title Case, Part 1

Links

• DDQ Not SQ
• Double Double Quotes

Recommended Courses

• Arrays in Access Developer 21
• Access Developer Courses

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, 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