Changing case in database

[Guest]

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?

 

[fredg]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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