Convert Upper Case to Title Case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported data from another source in capitals. Want to convert it to
Title Case. Eg: First letter of each word capitalised. Can anyone suggest
a simple method of doing this without writing a program.

Using MS Access 2002.
 
I have imported data from another source in capitals. Want to convert it to
Title Case. Eg: First letter of each word capitalised. Can anyone suggest
a simple method of doing this without writing a program.

Using MS Access 2002.
Click to expand...

By Title Case I Assume You Mean Something Like This!

You can run an Update query to convert your existing data to what is
called Proper Case.

Update YourTable Set YourTable.FieldName = strConv([FieldName],3)

Note: this will incorrectly capitalize some words which should contain
more than one capital, i.e. O'Brien, MacDonald, IBM, Jones-Smith, ABC,
etc., and incorrectly capitalize some words that should not have any
capitals, or whose capitaliztion depends upon usage, such as e. e.
cummings, abc, van den Steen.
Then some names can be capitalized in more than one manner, depending
upon personal preference, i.e. O'Connor and O'connor, McDaniels and
Mcdaniels, etc. are both correct.

You can create a table of exceptions and have some code that uses a
DLookUp with a message if one of the exception words is found.
 
Sure. Use the StrConv function in an update query.

Start by making a backup of your database. Then create a SELECT query that
includes the field that you wish to update. Convert this query to an UPDATE
query in query design view (Query > Update Query). You should see a new row
in the QBE grid titled "Update To:":

Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)


Tom
_______________________________________

:

I have imported data from another source in capitals. Want to convert it to
Title Case. Eg: First letter of each word capitalised. Can anyone suggest
a simple method of doing this without writing a program.

Using MS Access 2002.
 
Back
Top