how may characters in String data type?

[rocco]

Hello
i declared a variable
dim myvariable as string

I need it to hold as many characters as possible. It is in a loop. It's
value can go from being only one character to be more the 20,000.
Now..
When I run my code, it comes out that it holds a maximum of 255 characters.
I have seen in the help that there are two kinds of string data type:
fixed lenght: holds a maximum of around 65,000
variable lenght: holds near 2 billion characters.

But as far as I know you can just declare a variable as string...you don't
have option to choose which kind of *string*. And why is it said that the
smaller can hold around 65,000 characters when mine holds a max of 255?

Thanks...

 

[rocco]

sorry... I was wrong. The variable really holds all the necessary characters
....it's the field that doesn't hold more than 255 even if a setted it as
Memo....why?

 

[Brian Smith]

sorry... I was wrong. The variable really holds all the necessary characters
...it's the field that doesn't hold more than 255 even if a setted it as
Memo....why?

Don't memo fields have a limit of 65K characters?

Brian

 

[rocco]

I have solved the problem thanks to another topic in the newsgroup. Next time
I will search BEFORE writing.
Thansk

 

[david epsom dot com dot au]

Memo fields are limited to 2GB

The Access interface for Memo fields is limited to 64K.

To get more you have to use the dao CHUNK methods or equivalent.

Strings are limited to available memory or 2GB, whichever is less.

Memo fields (2GB) are converted to string fields (255)
sometimes, it depends what you are doing.

(david)