Hi,
I have a table which contains a field called firstname and all the letters are in uppercase, how do I convert it in such a way that , only the first letter is in uppercase and all other letters are in lowercase?

Thanks , please let me know.

Use an UPDATE query.

I like your poll:D I voted for Urgent Please:D
Sorry! Your little mistake was just too funny.

Welcome in the forum.

For your problem, I suggest you take a look at "vbProperCase"

OK, use an UPDATE query using the StrConv() function.