String variable is limited to 256 characters

  • Thread starter Thread starter Rick
  • Start date Start date
R

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.
 
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
 
Unless he's storing this string in a Text field, I don't think anything on
these pages applies.


Rob
 
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.
 
Back
Top