Table format - proper cases

  • Thread starter Thread starter Kayt
  • Start date Start date
K

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.
 
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.
Click to expand...

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