Proper() Function

[shamas21]

Hi All

I have been looking around but cant find the solution to this problem.

I have customers providing their first and last names in the wrong case

e.g. "boB dylAn"

Sounds bizzare why people do it, but they do.

I need my Access Query to convert them to the Proper Case....

e.g. "Bob Dylan"

I know in excel theres a Proper() function that does this.. but in access there is not... is there anything that anyone can give me like a function that does this?

Many Thanks

 

[Atomic Shrimp]

In Access, it's:

StrConv([yourstring], vbProperCase)

 

[shamas21]

In Access, it's:

StrConv([yourstring], vbProperCase)

Many Thanks

Thats fantastic

 

[Rx_]

FYI Access 2007 - I could not get the constanct vbProperCase to work.
But, the number worked just great!
My F2 Object Browser appears to show the constant.

e.g. NewTown: StrConv([TownBoard],3)

StrConv([yourstring], vbProperCase) 'NOTICE - must use numbers, vb constants don't work
' Hard to find - in Excel it is Proper(yourstring)
'vbUpperCase 1 Converts the string to uppercase characters.
'vbLowerCase 2 Converts the string to lowercase characters.
'vbProperCase 3 Converts the first letter of every word in string to uppercase.
'vbWide 4 Converts narrow (single-byte) characters in string to wide (double-byte) characters. Applies to Far East locales.
'vbNarrow 8 Converts wide (double-byte) characters in string to narrow (single-byte) characters. Applies to Far East locales.
'vbKatakana 16 Converts Hiragana characters in string to Katakana characters. Applies to Japan only.
'vbHiragana 32 Converts Katakana characters in string to Hiragana characters. Applies to Japan only.
'vbUnicode 64 Converts the string to Unicode using the default code page of the system. (Not available on the Macintosh.)
'vbFromUnicode 128 Converts the string from Unicode to the default code page of the system. (Not available on the Macintosh.)