Returns a Variant (String) converted as specified.
Syntax
StrConv(string, conversion, LCID)
The StrConv function syntax has these named arguments:
| Part | Description |
|---|---|
| string | Required. String expression to be converted. |
| conversion | Required. Integer. The sum of values specifying the type of conversion to perform. |
| LCID | Optional. The LocaleID, if different than the system LocaleID. (The system LocaleID is the default.) |
Settings
The conversion argument settings are:
| Constant | Value | Description |
|---|---|---|
| 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. |
| vbNarrow* | 8* | Converts wide (double-byte) characters in string to narrow (single-byte) characters. |
| vbKatakana** | 16** | Converts Hiragana characters in string to Katakana characters. |
| vbHiragana** | 32** | Converts Katakana characters in string to Hiragana characters. |
| 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.) |
*Applies to East Asia locales.
**Applies to Japan only.
Note These constants are specified by Visual Basic for Applications. As a result, they may be used anywhere in your code in place of the actual values. Most can be combined, for example, vbUpperCase + vbWide, except when they are mutually exclusive, for example, vbUnicode + vbFromUnicode. The constants vbWide, vbNarrow, vbKatakana, and vbHiragana cause run-time errors when used in locales where they do not apply.
The following are valid word separators for proper casing: Null (Chr$(0)), horizontal tab (Chr$(9)), linefeed (Chr$(10)), vertical tab (Chr$(11)), form feed (Chr$(12)), carriage return (Chr$(13)), space (SBCS) (Chr$(32)). The actual value for a space varies by country for DBCS.
Remarks
When you're converting from a Byte array in ANSI format to a string, you should use the StrConv function. When you're converting from such an array in Unicode format, use an assignment statement.