Continuing code on a new line in a module.

[JUDO]

How can you continue code within a module on a new line?

 

[Mile-O]

You can do it by using the _
character at the end of _
a line or wherever you _
want.

 

[Shadez]

You can do it by using the _
character at the end of _
a line or wherever you _
want.

Mile,

just to expand,

to stretch a string over more than one line you need to close the string at the end of each line. This is to allow the compiler to see the _. if you dont do this the _ is just seen as text in the string and an error will occure on the following lines.

ie

str = "select * " & _
           "From Sometable " & _
           "Where SomeFiled = 'xyz'"

Another one to look out for, Expecialy when using this method to split Sql statements in to lines(in code), is the existance of
spaces between lines.

 

[Mile-O]

And:

you can do it with comments too

ie.

Debug.Print "Mile-O-Phile" ' This prints _
 out my screen name _
 so you can see it