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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

String is to short for SQL sentence 2
Recordset Source 3
chop off last 5 characters of a string 9
Strings - variable-length string 12
how may characters in String data type? 4
VBA Recordset Query String Length Limit 6
VBA: How can I use a string variable as autofilter criteria? 4
Example Of VBA SQL Statement 0

Back
Top