Table of contents
TOC
Collapse the table of content
Expand the table of content

String Data Type

office 365 dev account|Last Updated: 8/16/2017
|
2 Contributors

There are two kinds of strings: variable-length and fixed-length strings.

  • A variable-length string can contain up to approximately 2 billion (2^31) characters.

  • A fixed-length string can contain 1 to approximately 64K (2^16) characters.

    Note A Public fixed-length string can't be used in aclass module.

The codes for String characters range from 0-255. The first 128 characters (0-127) of the character set correspond to the letters and symbols on a standard U.S. keyboard. These first 128 characters are the same as those defined by theASCII character set. The second 128 characters (128-255) represent special characters, such as letters in international alphabets, accents, currency symbols, and fractions.

Thetype-declaration character for String is the dollar sign ( $ ).

A double-quotation-mark can be embedded within a string literal in one of two ways:

  • Use two double-quotation-marks:

      Dim s As String
      s = "This string literal has an embedded "" in it."
    
  • Use the Chr function; character code 34 is a double-quotation-mark:

      Dim s As String
      s = "This string literal has an embedded " & Chr(34) & " in it."
    
© 2017 Microsoft