If it is a string, then you can do as in this example where the long string of text is continued on 2 additional lines
Code:
Dim SQLInterim as string
SQLInterim = "INSERT INTO VaUser ( EmplId, [Employee Name], [Payment Amount],[Payment Date]," _
& "[Payment Number] )" _
& " SELECT VATrans.EmplId, VATrans.[Employee Name], VATrans.AmountofPaymentsInBetween,"
Here is another - spread across several lines
Code:
Dim sqla As String
sqla = "CREATE table tblxmlnodes" & _
"(id counter, nodeparent Number " & _
" , nodename varchar(50)" & _
" , nodechain varchar(250)" & _
" , nodelevel varchar(20)" & _
" , nodeorder NUMBER " & _
" , nodeleaf varchar(30)" & _
" , nodeValue varchar(250));"
For your data, I would probably put them into a table.
Another option is to put the values in an array.
Dim colorFPArr(2) as string
ColorFP(0) ="0MA114"
ColorFP(1) ="0MA115"
ColorFP(2) ="00A050"
If you have a long list of text values, you could put them into a table.
Depends on what you're trying to accomplish.