This content has been marked as final. Show 3 replies
Finally solved it myself. Kudos to me! Exported the offending field contents to a text file then used the excellent "Text Soap" application to apply capitalization (i.e. Titlecase), then re-imported it into the PROCEDURES table into the "procedure name" field.:smileyvery-happy:
Using the Proper ( textfield ) function, you can apply title case directly to the text in a field (Instead of formatting the field's settings on a layout) without having to export and re-import the data.
Thanks for your reply, Phil. Yes, I applied the infamous "Text formatting" functions to the offending field contents. As I mentioned, the result was that text looked fine in the source table and layout where I performed the loop script to apply text formatting. However, the menu generated by the value list continued to show mixed case entries. Very weird.