Outlook 2000 - Strings

  • Thread starter Thread starter -mike-
  • Start date Start date
M

-mike-

Hello,

I have a big problem

Look at this smal Program:

Dim a As String

Private Sub UserForm_Click()
a = String(1024, "0")
Debug.Print a
End Sub

I think this programm generate a String with 1024Byte.
But the string is 256Byte long !?!??

Why ????

I found nothing in the web.

Thank you

Bye

P.S.: I have a big SQL statement longer than 256Byt
 
Look at the Help entry for the String function. It says explicitly
that it only will use the first 256 characters. If you want a longer
string either repeat the String function concatenate multiple strings
into one.
 
Back
Top