String Data Type

[Brad]

The text below is copied from Help in Access97.

How do you define a String data type as a Variable-Length String?

If you do

Dim x As String

x is only 255 characters. By definition below, a variable-length string is
2 billion.

Help?

---------------------------------------------------------------------------

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 a class 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 the ASCII character set. The second 128 characters (128–255)
represent special characters, such as letters in international alphabets,
accents, currency symbols, and fractions.The type-declaration character for
String is the dollar sign ($).

 

[Ken Snell [MVP]]

ACCESS uses only as much memory as the text string is long. So,

Dim x As String

is the normal, preferred way to dimension a string variable. If x only
contains 255 characters, then it occupies only 255 characters worth of
memory.

 

[Dirk Goldgar]

ACCESS uses only as much memory as the text string is long. So,

Dim x As String

is the normal, preferred way to dimension a string variable. If x only
contains 255 characters, then it occupies only 255 characters worth of
memory.

Well, 255 characters plus a few bytes of overhead.

 

[Ken Snell [MVP]]

You mean "groupies"? ACCESS has "groupies"?

< g >

 

[Dirk Goldgar]

You mean "groupies"? ACCESS has "groupies"?

You mean yours don't follow you around all the time?

 

[Ken Snell [MVP]]

heck no... my family doesn't even do that < g >