Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    135
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change All Caps to Title Case (Access 2000)

    I want to change about 600 records from All Caps to Initial Caps. I suspect I can only do this in Excel. Can I cut & paste, or export & then import? If I make changes in a Query, will the changes modify the table data?)

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change All Caps to Title Case (Access 2000)

    Let's assume you have a field named FULLNAME, your table is tblClients. You may use an update query, updating your fullname field as such:

    Update To: StrConv([tblClients].[fullname],3)

    The 3 indicates Proper Case, you may use 1 for upper case, or 2 for lower case.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change All Caps to Title Case (Access 2000)

    Similar to Jeremy's last answer. You do not necessarily have to do an update query, but create a select query from your table and add a field say

    TitleCase: strConv([MyFieldName],3) you can switch off the visibility of the uppercase field
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •