how to change letter cases in an access database

[botswanacitizen]

hello

I have a large access database that I need to clean up. Basically I
want to make all the username in the field with the first letter upper
case and make it look nice.

The autocorrect doesn't seem to work for existing databases.

So I do I make the fields look all the same without mixture of upper or
lower cases?

thanks

 

[Douglas J Steele]

Try an update query, using the StrConv function.

My advise would be to add new fields to the table and set them, then delete
the existing fields once you're satisfied. Either that, or make copies of
the tables first, just in case the updates don't work the way you want them
to.