Word Wrap in Access VB (MSAccess 2007)

[rcrobman]

Is there a way to have a word wrap function in the Access VB window in Access 2007? When writing code quite often the code is much bigger than the window BUT if you hit enter to wrap the code manually the software takes it as a new instruction line. I have tried putting & before or after the new line but to no avail. It would be a lot simpler to follow the code if you didn't have to scroll across the window to keep reading it!
I have looked at all the menu options and don't see one to accomplish this.
Thanks if you can tell me what I am missing!

[pbaldy]

To my knowledge there's no automatic way. The combination of a space and an underscore is VBA's line continuation character, which lets you write code on multiple lines:

  strSQL = "SELECT Count(*) AS HowMany FROM CarMaint.dbo.Car_Records " _
         & "WHERE car_no = " & varCarNum & " AND Company_no = '" & Me.CarComp & "'"

[rcrobman]

Well that would explain why all the code examples that MS shows in the help file show the _ & .
I thought it was just showing that the code continued but was being displayed that way!
Thanks for the help!

[pbaldy]

No problemo!

[caddcop]

Note that you cannot use the _ in the middle of a string. IOW, you cannot do...
"This is some very long string _
that continues on two lines"
You can however, do this...
"This is some very long string "_
& "that continues on two lines"
When is a line of code, the underscore is fine.