I took over an existing database and now all NEW RECORDS have Proper Case (John J Smith).
However, all the ALREADY existing records show up in all kinds of cases in the TABLE. ALL UPPER, ALL LOWER and various combinations of both.
I need a VBA for Access code for reading each Name field, converting to Proper Case, and saving it IN THE TABLE as proper case.
Can anyone help???
Thanks,
Alan AbramowitzA@coned.com
