By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,756 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

convert strings to proper case

P: 53
Hello please can someone help me with the problem of automatically changing the first letter of surnames and names into capital letters.
i am able to do the postcode where in the format box i typed in ">", to get all the letter inm capital letters. i do not know if the character lenght is important.
cheers
Feb 24 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,597
Hello please can someone help me with the problem of automatically changing the first letter of surnames and names into capital letters.
i am able to do the postcode where in the format box i typed in ">", to get all the letter inm capital letters. i do not know if the character lenght is important.
cheers
The StrConv() Function with the vbProperCase Parameter will convert the first letter of every word into Upper Case.
Expand|Select|Wrap|Line Numbers
  1. Debug.Print StrConv("john wilkes booth",vbProperCase)
  2.  
  3. Output:
  4. John Wilkes Booth
Feb 24 '07 #2

P: 53
The StrConv() Function with the vbProperCase Parameter will convert the first letter of every word into Upper Case.
Expand|Select|Wrap|Line Numbers
  1. Debug.Print StrConv("john wilkes booth",vbProperCase)
  2.  
  3. Output:
  4. John Wilkes Booth

thankyou for your help, and i am sorry for the late reply
i do not understand what the vbProperCase Parameter is and i tried to directly pate this into the code format in access but it did not work. have you got any sugesstions.
cheers for your help, much appreciated!
Feb 26 '07 #3

ADezii
Expert 5K+
P: 8,597
thankyou for your help, and i am sorry for the late reply
i do not understand what the vbProperCase Parameter is and i tried to directly pate this into the code format in access but it did not work. have you got any sugesstions.
cheers for your help, much appreciated!
The 2nd Parameter to the StrConv() Function, in this case vbProperCase, tells the Function what display format to produce the result in. in this specific case, vbProperCase tells the Function to convert the first letter of every word in the string to uppercase. I see no reason why it will not work for you. Please post your code and I'll have a look.
Feb 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.