has anyone ever forced a last name into
TitleCase in the datatable? I know you can use ">" to
force upper case, but
what about title?
Use a form to enter the data.
In the AfterUpdate event of the control on the form:
[ControlName] = StrConv([CountrolName],3)
Be aware that this will not properly capitalize all words and names,
as some names must always be in all caps (IBM, CBS, etc.), some never
capitalized (e.e. cummings), some have 2 capitals in the name
(McDonald, O'Connor) and some have a mixed set of capitalized names
(van der Meer), as well as all hyphenated names.
The most efficient way, that I know of, to accurately handle names
like these is to have a table of exceptions, and DLookUp the table for
that particular word before changing it.
You would need to create a User Defined function to do all of this and
regularly maintain the list of names, adding new words as needed.
And, after all is said and done, there are still some words and names
that can be written both ways (O'Connor, O'connor, McDonald, Mcdonald)
as well as others whose capitalization depends on useage (ABC, abc,
Xerox, xerox, Access, access).
