Proper(), LCase(), LCase$()

[hycho]

Hi,

I am trying to convert "HELLO123!" into "Hello123!".

In MS Excel, I can use this function:

Proper(HELLO123!)=Hello123!

Is there a function in MS Acess 2003 to turn words into proper cases? Or is there a way I can get the desired results using a combination of functions?

Also, what's the difference between LCase() and LCase$()?

Thanks.

 

[Adam Caramon]

Proper(HELLO123!)=Hello123!

Take a look here: http://www.techonthenet.com/access/functions/string/strconv.php

 

[vbaInet]

StrConv() is what you're looking for. And make sure to use the Integer equivalent, not the VBA constants:

http://www.techonthenet.com/access/functions/string/strconv.php