String variable is limited to 256 characters

[Rick]

I'm trying to put a SQL statement into VBA using a string variable. The
variable will only hold 256 characters of my SQL statement, so it's chopping
it off. I know I can work around this in several ways, but does anybody know
why a string variable will only hold 256 characters?

Thanks.

 

[Robert Morley]

There's never been that small of a limitation on String variables that I'm
aware of. Perhaps you could post your code and we can see if there are any
obvious problems with it.


Rob

 

[Steve Sanford]

Check out these sites:


http://www.mvps.org/access/general/gen0011.htm


http://www.databasedev.co.uk/access_specifications.html



HTH

 

[Robert Morley]

Unless he's storing this string in a Text field, I don't think anything on
these pages applies.


Rob

 

[Steve Sanford]

You're right. I was reading faster than I was understanding.

 

[Rick]

Ok, I believe it's a screen limitation only. When I view the variable in the
Locals window, it is truncated; so I've read somewhere. You're correct,
there is not a 255 limitation on string variables.

If I continue to have problems, I will post my SQL statement later. Thanks.