Continuing VBA statement 1

[projecttoday]

This may be a dumb question, but I can't find the answer in the help. How do you continue a statement, specifically one that contains a long character string and you want to maintain spaces.

Dim str as string
str = "the quick brown fox jumped
over the lazy dog"

How to continue the assignment above while maintaining a space after jumped. I tried using _ at the end of the line but it didn't work.

 

[TheAceMan1]

How are ya projecttoday . . .

You concatenate using the line continuation character ( a space followed by an underscore character. Giving you:

[blue]str = "the quick brown fox jumped" & _  
      "over the lazy dog"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[boblarson]

TheAceMan1 - You missed including the space so it would need to be either this:

str = "the quick brown fox jumped " & _  
      "over the lazy dog"

or this:

str = "the quick brown fox jumped" & _  
      " over the lazy dog"

Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[TheAceMan1]

Howdy boblarson . . .

Yeahhhhhhhh . . . but I got the line continuation character right! . . . what [blue]projecttoday[/blue] wanted!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[MajP]

I like to use this concept of adding to the string. This is helpful for long strings with variables in it. Especially helpful with a long sql strings. It allows you to debug the string in parts.

dim str as string
str = "The brown fox jumped "
str = str & "the lazy dog "
'debug.print str
str = str & "on " & date() & ". "
'debug.print str

 

[TheAceMan1]

Howdy MajP . . .

Same here! I use it all the time for [blue]formatting the readability of strings & code![/blue] I never have a problem deciphering my code . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

projecttoday . . .

Forgot to mention you can also use the [blue]line continuation character[/blue] to format your code for [blue]easier readability.[/blue] Examples:

[blue][purple]Non-Formatted:[/purple]
Public Sub AnyRoutine(Mth As Integer, Dy As Integer, Yr As Integer, Wk As Integer, frmName As String, sfrm1Name As String, sfrm2Name As String, sfrm3Name As String, Amt1 As Currency, Tlt As Currency)

[purple]Formatted:[/purple]
Public Sub AnyRoutine(Mth As Integer, _
                      Dy As Integer, _
                      Yr As Integer, _
                      Wk As Integer, _
                      frmName As String, _
                      sfrm1Name As String, _
                      sfrm2Name As String, _
                      sfrm3Name As String, _
                      Amt1 As Currency, _
                      Tlt As Currency)[/blue]

[blue][purple]Non-Formatted:[/purple]
SQL = "SELECT FirstName, LastName, Initial, Address From tblClients WHERE [LastName] Like '*Ace*';"

[purple]Formatted:[/purple]
SQL = "SELECT FirstName, LastName, Initial, Address " & _
      "From tblClients " & _
      "WHERE [LastName] Like '*Ace*';"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886