LCase? Title Case?

Is there a way to change: GEORGE BUSH to George Bush ??


Thank you all

Bre-x

The VBA expression would be

StrConv("GEORGE BUSH",3)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Bre-x wrote:
Is there a way to change: GEORGE BUSH to George Bush ??


Thank you all

Bre-x

On Wed, 7 Jan 2009 12:16:55 -0700, Bre-x wrote:

Is there a way to change: GEORGE BUSH to George Bush ??

Thank you all

Bre-x

Perhaps changing it to george bush would be more appropriate!
Sorry, I couldn't resist. :-)

On the Form's control's AfterUpdate event code:
Me![ControlName] = 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thank you, it works very well

"Bre-x" wrote in message
...
Is there a way to change: GEORGE BUSH to George Bush ??


Thank you all

Bre-x