Upper/Lower Case Changes

[roxannep]

I have recently "inherited" a database and in designing and running reports, I have found that the original programmer inserted the ">" sign into many of the tables' fields' format property.

Problem: when producing some reports, we need names to show in upper and lower case (Proper case) in personalized letters for example. Because the tables' fields actually had the > inserted as a property, data entry operators have run the gamut on their case usage, so that while they saw JOHN SMITH on their screens, they actually entered (and stored) any of the following variations (bold for emphasis only):

JOHN SMITH
John Smith
john smith
John smith
john Smith

I need to have the data stored in their tables in Proper Case, but I need to know how to do this throughout the entire database (the programmer used this property this in the address field, the city field, the products, etc.). Can someone direct me as to the easiest way to get this "restored."

Please give specifics ... not just StrConv(string, vbProperCase ... how and where do I apply this.

Thanks in advance for the assist! What a nightmare!

 

[JoeMiller]

First off you can see my FAQ here: faq181-790. Which discusses the usage of StrConv. As far as going through the DB you'll have to run Update queries and the updates will utilize StrConv to convert the field upon itself. Once that is done, you should be all set. If you need help with an update query, let me know! Joe Miller
joe.miller@flotech.net