By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,668 Members | 1,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,668 IT Pros & Developers. It's quick & easy.

Long String

P: n/a


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,
--------------------------------------------------------------------------


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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,

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.