length of string variables

  • Thread starter Thread starter access newbie
  • Start date Start date
A

access newbie

I've got a select string I'm modifying programmatically
based upon an option group's setting, and the string is
being truncated (I can only see to roughly 225 characters
in the locals window of the debugger). Is there a way to
tell VBA that it's a longer string variable, or is there a
more appropriate variable type to use instead of string?
TIA!
 
you could put vbcrlf's into the string to make it more readable
ie
"SELECT .... " & vbCrlf & _
"FROM .... " & vbCrlf & _
"WHERE ... " & vbCrlf & _
"AND ...."
etc

HTH
Pieter
 
Pieter,
Thanks for the quick reply. What I was really concerned
about wasn't readability. I thought my select string
might have been getting truncated due to a limitation on
the length of the string which can be put into a 'string'
variable in VBA. What I was seeing was a truncation in
the locals window of the debugger, but I decided to go
ahead and try the code and it works anyway.
Must be a limitation in the debugger. :| Kinda
misleading, but now I know.
Thanks again!
 
Back
Top