To break a single statement into multiple lines

[mhcha]

hello,

If one line of code is long, is there a way to change it to the next line and continue writing? Long code makes it less readable.

ex)
cmd.CommandText = _
"SELECT * FROM Titles JOIN Publishers " _
& "ON Publishers.PubId = Titles.PubID " _
& "WHERE Publishers.State = 'CA'"

[Grovkillen]

Use the labeltovar command.

[mhcha]

excellent!
Now it works as i want.
Thank you Grovkillen.

[JRL]

Could one of you post an example?

[mhcha]

Yes I will post an example for others.

Ex)

Code: Select all

MDL>text1%CRLF%text2%CRLF%text3%CRLF%text4%CRLF%text5%CRLF%text6%CRLF%text7%CRLF%text8

In the case of the example above, you can change it to:

Code: Select all

/*
Text:
text1
text2
text3
text4
text5
text6
text7
text8
*/

LabelToVar>Text,MyText,1,0,*/
MDL>%MyText%