Okay, a really cool feature of MS Word is to change the case to upper or lower, or Title, or whatever. I know there are some basic pre-defined functions in Access to change things to LCase or UCase, but what I really want is Title Case! If it is impossible, okay, but it seems like very few things are impossible. If I have to Export all these names out to Excel, and then copy to Word, and then change the case, and somehow get it back into Access, then I'll do it. But I thought I would check and see if there were some programming tricks which would help with this.
If not convert them, at least I would like to be able to identify which records have the field populated with all UPPERCASE characters, so I can just pull those records out. Thank you!
Start Free Trial
