Proper

[captnk]

Xl contains a function +proper(......

This converts the first letter of each word in a text string,to a Capital (upper case),with the balance of the word as lowercase.
(very useful function)

I can Access options for upper/lower case but this appears to be an all or nothing situation.

Does access have any function similar to "+proper"

 

[Mile-O]

Use the StrConv() function.

i.e.

strMyString = StrConv(strMyString, vbPropercase)