Changing existing text from upper to lower case.

  • Thread starter Thread starter Rod Swank
  • Start date Start date
R

Rod Swank

I inherited a database listing the membership of an
organization I belong to. All the entries are in
UPPERCASE. How can I convert them to lower case with
leading capitals only, such as the first letter of a name,
place or sentence.
 
Rod,
To capitalized just the first letter of a field like this:
=UCase(Left([FieldName],1)) & LCase(Mid([FieldName],2))

To Change To Proper Case Like This:
=StrConv([FieldName],3)

In either case you will get improper results, as some words, IBM, NBC, etc.,
are supposed to be all caps and others (McDonald, O'Connor, van Steen etc.)
are supposed to be mixed upper and lower case, while some names, (e. e.
cummings) are supposed to be lower case.
These will have to be separately taken care of.
You can have a table of exceptions and search each field after conversion as
to whether that exception is in the field.
 
In an Update Query, use the following syntax in the UpDate to line for your
field containing the name:

StrConv([MyName], 3)
 
Back
Top