Results 1 to 2 of 2
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919

    I can't do "This"? (Object issue)

    I get a "Object Required" error on the 2nd of the two assignment statements. I'm simply wanting to change elements of "NameArr" to consistent use of case. E.g., WASHINGTON to Washington or something like washington to Washington



    [CODE For I = 0 To 1 'Fix any inconsistent use of case in the names
    NameArr(I) = LCase(NameArr(I))
    Left(NameArr(I), 1) = UCase(Left(NameArr(I), 1))
    Next][/CODE]

  2. #2
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    I just changed the assignment statement to:

    NameArr(I) = UCase(Left(NameArr(I), 1)) & Right(NameArr(I), Len(NameArr(I)) - 1)

    All is well.
    Thanks,
    Bill

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

Similar Threads

  1. Replies: 1
    Last Post: 03-14-2013, 12:39 PM
  2. Replies: 6
    Last Post: 10-04-2012, 01:43 PM
  3. Replies: 1
    Last Post: 04-10-2012, 08:48 AM
  4. Replies: 0
    Last Post: 02-20-2012, 04:57 PM
  5. Replies: 0
    Last Post: 01-11-2012, 12:34 PM

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