Wrap results of debug.Print?

[arage]

Wrap results of debug.Print?
I’m examining my SQL statements in debugger, but some of them are quite long & I have to use the horizontal scroll bar back and forth to examine their run time results. Is there some way to get this statement to wrap onto several lines?

 

[Alexandre]

If you are building your SQL under VBA, then it is up to you to put carriage returns in appropriate places (VbCrLf) Ex:

strSQL = "SELECT blabla " & VbCrLf & _
          "FROM blabla " & VbCrLf & _
          "WHERE blabla" & VbCrlf & _
                "AND blabla"