does Access 2003 have a "proper" case? Upper case/then Lower

  • Thread starter Thread starter skyking
  • Start date Start date
S

skyking

Does Access 2003 have a "proper" case? I have a text field with names that
are all caps.
 
Does Access 2003 have a "proper" case? I have a text field with names that
are all caps.
Click to expand...
In a query?

NewColumn:= StrConv([ControlName],3)

Note: this will incorrectly capitalize some words which 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 capitalization 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 all correct.

You can create a table of exceptions and have the code use DLookUp
with a message if one of the exception words is found.
 
Back
Top