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]

Re: Long String

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" <quachkhanh@opt usnet.com.au> wrote in message
news:3ffa47e9$0 $18750$afc38c87 @news.optusnet. com.au...[color=blue]
>
> 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[/color]
long[color=blue]
> string, so how can I do that ? Please Help, Thank you,[/color]