Splitting code to span two lines

[DubboPete]

Hi all,

How does one break code up to wrap to more than one line, so that it
can be read more easily?

tia

DubboPete

 

[Rick Brandt]

Hi all,

How does one break code up to wrap to more than one line, so that it
can be read more easily?

In Access VBA the underscore is the line continuation character.

EX:

Dim strSQL as String

strSQL = "SELECT * " & _
"FROM TableName " & _
"WHERE SomeField = SomeValue"

 

[Rob Parker]

.... and there must be a space before the underscore!

Rob

 

[DubboPete]

... and there must be a space before the underscore!

Rob







- Show quoted text -

....and you gentlemen are true scholars!

thanks for your help

Pete