Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Access VBA Array Converting to Upper Case

    Apologies if explanation is not good?


    I have some VB Code which I found (Function) - which converts "text" from a table into Array (checked in Immediate Window & list display what I want) - It does what I want but also converts the first letter of each word to Capital!
    The "List" are all words / text in Capitals which I need to be in Capitals (e.g. COSHH, PPE etc.) in my other table

    My question is: how do I convert the "Description" field if I type in coshh or Coshh to COSHH (which is in the Array)

    Hope my explanation makes sense?

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 04-28-2019, 07:19 PM
  2. Change text case from upper to proper case
    By s.nolan in forum Access
    Replies: 1
    Last Post: 12-02-2015, 10:56 AM
  3. Replies: 5
    Last Post: 10-23-2012, 03:55 PM
  4. Upper & Lower Case in table
    By Forums10 in forum Access
    Replies: 4
    Last Post: 01-31-2011, 09:01 AM
  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