length of string variables

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!
 
P

Pieter Wijnen

you could put vbcrlf's into the string to make it more readable
ie
"SELECT .... " & vbCrlf & _
"FROM .... " & vbCrlf & _
"WHERE ... " & vbCrlf & _
"AND ...."
etc

HTH
Pieter
 
G

Guest

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!
 
Top