I've found in the help screen that to change text to "mixed case" you must
use the PROPER(text) function. Where exactly to I use this function to
change the text? And is this something I have to do for each field?

On Wed, 15 Feb 2006 10:46:29 -0800, Tracy wrote:

> I've found in the help screen that to change text to "mixed case" you must
> use the PROPER(text) function. Where exactly to I use this function to
> change the text? And is this something I have to do for each field?

What help screen?
Proper() is an Excel function.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

In Access, the proper function to change to Title case is StrConv(Field, 3).
You would use it in a SQL update query like this:
UPDATE TableName SET Field1=StrConv(Field1, 3), Field2=StrConv(Field2, 3) etc.

Note, however, that this function is far from foolproof - It doesn't handle
words that should have internal caps, like MacDonald or PO Box.
--
Ted

Thank you so much! It worked great. Can you use this function for updating
the entire table rather than typing it for each field?

"TedMi" wrote:

> In Access, the proper function to change to Title case is StrConv(Field, 3).
> You would use it in a SQL update query like this:
> UPDATE TableName SET Field1=StrConv(Field1, 3), Field2=StrConv(Field2, 3) etc.
>
> Note, however, that this function is far from foolproof - It doesn't handle
> words that should have internal caps, like MacDonald or PO Box.
> --
> Ted
>

No, you must specify the update separately for each field.
--
Ted