maximum string length?

[trinity85]

Is there a maximum string length?

Thank you for the help

 

[gol4]

from access 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.

 

[trinity85]

Thank you but for some reason it wont let me write more than around 256 characters in a string... do you know why?

 

[trinity85]

actually it lets me, but it truncates the string

 

[PHV]

How is this string Dim'ed ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[trinity85]

as string

 

[gol4]

if you are then pasting it in a text field then the field will limit it to 255 unless it is a memo filed is that perhaps your problem?

 

[trinity85]

Thank you but it truncates it even before copying it in a field (and that would have been a memo). I just do
Dim test as string
test = "some long string"

and put a break point here and the string is truncated to somewhere around 256 chars ....

 

[missinglinq]

Trinity85,

Everyone's talking about where you're pasting the string into, but I don't see where you're actually entering the string. If you're entering it into a text field, it'll limit it to 256 characters. If you're actually entering it into a memo field (where it's got to go if you plan on it going into a table) it should allow it.

The Missinglinq

There's ALWAYS more than one way to skin a cat!