How can all Upper Case letters to changed to mixed case in Access 2007?

Posted on 2011-05-03
Last Modified: 2012-06-27
The data coming into the Access 2007 database is in all CAPS. I need to translate all Upper case letters to mixed case. I am currently using:

 Mid(UpperCaseString,1,1) & Mid(LCase(UpperCaseString,2,254)) to get the 1st letter in CAPs and the following letters in lower case.

 Is there an easier  way to have all upper case letters changed to 1st letter upper case and all other letters lower case (for all words separated by a space) in UpperCaseString?

Question by:newbie46
    LVL 119

    Accepted Solution

    use strconv()


    Author Comment

    LVL 119

    Expert Comment

    by:Rey Obrero
    you can run an update query

    update table
    set [fieldName]=strconv([fieldname],3)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now