Access 2016 VBA break line

[Dick7Access]

Access 2016 VBA I can’t break my lines of code. I have googled for hours and I have tried every combination of [ _ & ] I can think of. What’s the secret?

 

[MarkK]

The line continuation character is space + underscore, so " _"

If you are constructing a string, then you need to terminate the string, ampersand it to the next line, add your line continuation, and then restart your string, like...

dim tmp as string
tmp = "This is a string that is so long, we will continue its " & _
   "construction on the next line."

...but otherwise you can just continue the line, like...

Private Function LongListOfParams( _
   Param1 as string, _
   Param2 as string, _
   Param3 as string)

Mark

 

[Dick7Access]

The line continuation character is space + underscore, so " _"

If you are constructing a string, then you need to terminate the string, ampersand it to the next line, add your line continuation, and then restart your string, like...

dim tmp as string
tmp = "This is a string that is so long, we will continue its " & _
   "construction on the next line."

...but otherwise you can just continue the line, like...

Private Function LongListOfParams( _
   Param1 as string, _
   Param2 as string, _
   Param3 as string)

Mark

Thanks, that did it. I was missing [" " ].What the google spots I found did not include the [" " ] at the second line.

 

[Cronk]

The placement of the ampersand is not critical. I normally put the & at the start of the next line to show me that the line is a continuation as well

tmp = "This is a string that is so long, we will continue its "  _
 & "construction on the next line."

 

[The_Doc_Man]

Interesting visual aid, Cronk. I like it.

 

[Cronk]

Doc,

Exactly my reaction when I saw it in a db I was working on, developed by someone else.

 

[MarkK]

Funny, because I like it at the end of the line. Find it looks dorky hanging off the front. Preference.

 

[Galaxiom]

The placement of the ampersand is not critical. I normally put the & at the start of the next line to show me that the line is a continuation as well

tmp = "This is a string that is so long, we will continue its "  _
 & "construction on the next line."

Additionally I align the ampersand with the eqals and always put any spaces at the beginning of the line where they are easily confirmed

strSQL = "SELECT blah" _
       & " FROM sometable"

The alignment avoids the "dorky" look mentioned by Mark.

 

[Minty]

It's a good job this forum isn't populated by nerds or the grammar police...


oh wait a minute