How to have a string longer than 255 chars

[The_Doc_Man]

Nothing wrong, just didn't want you to wait for one of the original participants to chime in.

 

[Wayne]

Break up your string into parts.

Dim strWhatever As String

strWhatever = "Blah, blah, blah..."
strWhatever = strWhatever & "More blah, blah, blah..."
strWhatever = strWhatever & "Still more blah, blah, blah..."

In this way, there is virtually no limit to the length of the string.

Wayne