Converting all data to uppercase

[wwiSports]

I have two databases that I am bringing together. When the data entry specialists are entering the data, everything they enter is in all caps, but we also download some information from our website--and when that information is downloaded, it is downloaded in whatever format the customer enters it on the web form. Is there a way that I can have the database convert all data to upper case?

Beth

 

[Rolliee]

Write a 'fixer' form event that goes thru all the data and resets string values to [fields(i)] = upper(fields(i)). The fields start at zero and go to fieldcount - 1.

email me if you do not understand this.

rollie@bwsys.net

 

[Bagger]

You can also set the default to UpperCase in the properity of the table. Select the field and in the field properity set the default value to > for all UpperCase or < for all LowerCase. This way you don't have to worry about converting the incoming data. Because you set the default in the table the data will always be displayed in uppercase.

HTH

 

[wwiSports]

I wont be able to set the default of the database to all caps. All the data is entered by the data entry specialists in all caps--except for one form, which is awards that kids have one--that is proper case. The downloads from the web are what i'm mostly wanting to change, so if I can add code into the download code that makes those all caps--then that would probably be the best idea.