Return a string converted to Upper/lower case or Unicode.
Syntax
StrConv(String, conversion [, LCID])
Key
String The string to convert.
conversion The type of conversion to perform.
LCID The Locale
Valid parameters for conversion:
| Parameter | Value | Description |
|---|---|---|
| vbUpperCase | 1 | Convert the string to all uppercase. |
| vbLowerCase | 2 | Convert the string to all lowercase. |
| vbProperCase | 3 | Convert the first letter to every word to uppercase. All other characters are left as lowercase. |
| vbUnicode | 64 | Convert the string to Unicode. |
| vbFromUnicode | 128 | Convert the string from Unicode to the default code page of the system. |
The StrConv() function can be used in VBA or in an SQL query.The vb constants are only valid in VBA code, to use strconv() in a query use the numeric value. In far east locales StrComp supports additional constants for converting Hiragana and Katana characters.
Examples
Dim strDemo as String
strDemo = StrConv("the universe is everlasting", vbProperCase)
MsgBox
strDemo
'Returns: "The Universe Is Everlasting"
“Where there is shouting, there is no true knowledge” ~ Leonardo da Vinci
Related:
CStr - Convert to String
Q298607 - How to use the StrConv function