Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    Bloomsburg, Pennsylvania
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formatting names (upper and lower case) (2000)

    I can't find any reference in the books I have, but is there a function that will format a text field so that the first character is upper case and the others lower?

    The data we have comes from a mainframe, and all names are in upper case. I'd like to format them to the proper case. I know I can use the left(), but thought there might be something that would do it smarter.

    Thanks for any help.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: formatting names (upper and lower case) (2000)

    You can use the StrConv( ) function with the vbProperCase conversion constant. This will capitalize the first letter of each word, while making all other letters lower case. Use like this:
    [Namefield] = StrConv( [Namefield], vbProperCase)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting names (upper and lower case) (2000)

    Not sure if this is what your looking for but check it out:
    http://oak.cats.ohiou.edu/~andersoj/inputmasks.html

  4. #4
    Lounger
    Join Date
    Apr 2002
    Location
    Bloomsburg, Pennsylvania
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting names (upper and lower case) (2000)

    That's exactly what I needed. Thanks so much!

  5. #5
    New Lounger
    Join Date
    Dec 2003
    Location
    Land O' Lakes, Florida, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting names (upper and lower case) (2000)

    I have a subroutine that is in a module that I have modified to do this. After bringing data down from our AS/400 I use the routine to convert names and addresses to upper/lower case. I have modified it to handle cases such as McBride, etc... Let me know if you are interested in getting it.

Posting Permissions

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