Frink1234 Posted November 6, 2005 Posted November 6, 2005 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?
-Queue- Posted November 7, 2005 Posted November 7, 2005 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.
Recommended Posts
This topic is 7054 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now