StrConv

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 may 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


© Copyright SS64.com 1999-2013
Some rights reserved