I've imported data (customer name, address, etc.) into a
table in Access. The information were all in uppercases,
thus the data in Access are now in uppercases. How can I
change the format in the tables to be proper cases? Not
everying will be correct (i.e HP will be Hp), but it
would save me a lot of work and fix only a few records
out of 500+ records.

Thank you.

On Thu, 18 Sep 2003 07:37:32 -0700, "Kayt" <(E-Mail Removed)>
wrote:

>I've imported data (customer name, address, etc.) into a
>table in Access. The information were all in uppercases,
>thus the data in Access are now in uppercases. How can I
>change the format in the tables to be proper cases? Not
>everying will be correct (i.e HP will be Hp), but it
>would save me a lot of work and fix only a few records
>out of 500+ records.

You can't do this with a Format - but you can with an Update Query.

Update the field to

StrConv([fieldnam], 3)

3 is proper case (1 is lower, 2 is upper - see the online help for
more).


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public