ALL CAPS

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a table of names that are listed in ALL CAPS
Is there a way to convert them into Proper?

THanks
 
try the following update query (in a *copy* of your database first), as

UPDATE TableName SET FieldName = StrConv([TableName].[FieldName],3);

you can use the StrConv() function to convert *to* all caps and to all lower
case, also. see the function topic in Access Help for more information.

hth
 
I have a table of names that are listed in ALL CAPS
Is there a way to convert them into Proper?

THanks
Click to expand...

You can use StrConv([FieldName],3) to capitalize just the first letter
of each word in the field.

Be aware that this improperly capitalizes certain names and words
which should have more than one capital letter, i.e. McDonald -
Mcdonald, O'Brien - O'brien, IBM - Ibm, NASA - Nasa, etc., and
capitalizes words which should not be capitalized i.e. van den Steen -
Van Den Steen, van Beethoven - Van Beethoven, e. e. cummings - E. E.
Cummings. Some names can be properly spelled both ways i.e. O'Connor
and O'connor.
 
Back
Top