Results 1 to 2 of 2
  1. #1
    s.nolan is offline Novice
    Windows 10 Access 2013
    Join Date
    Dec 2015
    Posts
    1

    Change text case from upper to proper case


    I just created a Access 2013 web app and imported a table that has certain fields in all upper case. I would like to display the results in proper case and don't know the best method to do that for certain fields.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    use the strconv function

    Target = StrConv(Target, vbProperCase)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Making sure first letter of word is Upper case.
    By rzw0wr in forum Programming
    Replies: 1
    Last Post: 06-21-2013, 08:31 PM
  2. Replies: 5
    Last Post: 10-23-2012, 03:55 PM
  3. Upper & Lower Case in table
    By Forums10 in forum Access
    Replies: 4
    Last Post: 01-31-2011, 09:01 AM
  4. Is there a way to force a field do be upper case?
    By newtoAccess in forum Access
    Replies: 1
    Last Post: 11-28-2010, 04:20 PM
  5. Forcing text to upper case
    By barrettp in forum Forms
    Replies: 10
    Last Post: 06-01-2010, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums