Long String

[Tu Quach]

Hi there

I use the statement like this

dim sql_str as string

I found my message got a character as "False
............................." in my Str_Sql, if I wish to have a real long
string, so how can I do that ? Please Help, Thank you,
--------------------------------------------------------------------------

[Allen Browne]

Access can understand a SQL statement up to 64K in size, and VBA supports
that with no problem.

Unless your string is longer than that, there must be some other factor at
work here.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tu Quach" <qu********@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...

I use the statement like this

dim sql_str as string

I found my message got a character as "False
............................" in my Str_Sql, if I wish to have a real long string, so how can I do that ? Please Help, Thank you,