Uppercase to Lowercase

[johnwiseman]

Hi.

I receive a .csv import file where the text in one column is all in uppercase. e.g

THE HOUSE ON THE HILL

This column is imported into an Access table.

Once in the table I need to convert the words so they appear as follows.

The House On The Hill

Can this be done?


Thanks in advance for any assistance.

John

 

[mp9]

You can use the StrConv function, which takes a format parameter - you can use vbProperCase as that parameter to capitalise each word in your field.

vbProperCase has a value of 3, so if you want to use a simple to query to modify your tabel it would be something like:

UPDATE YourTableNameHere SET YourFieldNameHere = StrConv(YourFieldNameHere,3);

http://www22.brinkster.com/accessory/