Table format - proper cases

[Kayt]

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.

 

[John Vinson]

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).