Change Upper Case to Title Case

B

BobbyOH

I have a number of records with a text field that has been entered using all
upper case letters. How can I change the text to Title Case or just have the
first letter of each word capitalized? I know I can change to all lower case
by using "<" but title case is what I need.

Thanks...
 
F

fredg

I have a number of records with a text field that has been entered using all
upper case letters. How can I change the text to Title Case or just have the
first letter of each word capitalized? I know I can change to all lower case
by using "<" but title case is what I need.

Thanks...
Click to expand...

= StrConv([FieldName],3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Title Case 3
Change case from caps to title 3
Change all upper case letters to lower case 2
Change text from lower case to upper case in Access 2007 1
Change from all UPPER case letters 5
Differences between lower case and upper case 4
Title Or Proper Case 5
Upper Case 1

Top