Converting Case

[jpanic]

I have data in a table in Access97 that was imported from another application. When the data is imported it is in all caps. I would like to change the data to First letter cap rest lower case. There may be more than one word in a field i.e. Bank One

Any suggestions??

Thanks

 

[KenReay]

HI

StrConv("YOUR DATA IN HERE", vbProperCase)

should do it
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[jpanic]

thanks...but I am not sure where to put this string....

 

[KenReay]

Hi

Make an update query, say the col you want to update is MyCol

in 'update to' of mycol put

StrConv([MyCol],vbProperCase)


run the query
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[jpanic]

Thanks for all your help so far. I finally got my syntax right and got the query to run. Problem now is that it says it is going to update the records. I give it the ok then I get an error message back that it did not update due to a type conversion failure.

any thoughts

 

[grnzbra]

One other thing to keep in mind is the possibility of acronyms like FBI, CIA, DEA, FLETC and FinCEN. (I maitnained a database for an organization of law enforcement intel analysts - IALEIA). If you have anything like that, you may have to go through it manually and re-capitalize them. I found the easiest way of doing that was to sort on the field which was being checked so they would all be together. The function could be re-written to check the field about to be changed against a table of acronyms and only do the change if a match was not found.