How to update to have first letter upper case, rest lower case in MS Access 2007?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Diana Le
    #1

    How to update to have first letter upper case, rest lower case in MS Access 2007?

    Help! I am trying to update some garbage data and need to get the first letter of the first and last name in upper case and the rest as lower case (first and last name are in the same cell).

    Any tips?
    Tags: None
    • dsatino
      Contributor
      • May 2010
      • 393
      #2
      go here:
      MS Access: Functions - Listed by Category
      http://www.techonthenet.com/access/functions/
      For easy reference, we have provided a list of all Microsoft Access functions sorted into categories such as string, numeric/mathematical, date/time, advanced/logical, domain aggregate, data type conversion, group by, and file/directory functions.


      click on the strconv function

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32661
          #3
          The conversion of the data itself can be done using :
          Code:
          StrConv({String Value}, vbProperCase)

            Comment

            Previous template Next
            Working...