Scenario: A user enters data into a field that has been formatted to show in Title Case, but the user enters all characters in lowercase. Those items are then used as a value list in a pop-up menu. The pop-up displays all items in the pick list in lowercase (although it will show the final choice in Title Case as I have formatted the field to do so). Is there a way to get the entire pick list to show in Title Case? I have specified the text formatting for each field and even added a TextStyleAdd calc for all fields. What am I missing?

Formatting only applies to the way a field is displayed, not the way its data is stored.

Try making the field an auto-enter calculation, with 'do not replace existing values' deselected, equal to Proper(yourFieldName). Then show all records, put your cursor into the field in Browse Mode, and select Records -> Replace Field Contents, specifying a calculation of yourFieldName. This will force the auto-enter calculation to update for existing records.