How do I extend a INSERT INTO line of code to the 2nd, third and fourth line???

[Alphix]

I have a INSERT INTO function line of code which is very long. I would like to make this one line of code visually appealing by vertically extending it to several lines.



How do I take each part of the code and make multiple lines?

For example:

ecSql = "INSERT INTO 04Event_Collector ([Date_Collection],[User_Name],[Machine_Number],[Time1Start],[Time1Stop],[UElapsed1],[Time2Start],[Time2Stop],[UElapsed2],[DElapsed2],[Event_Code2],[Time3Start],[Time3Stop],[UElapsed3],[DElapsed3],[Event_Code3],[Time4Start],[Time4Stop],[UElapsed4],[DElapsed4],[Event_Code4],[Time5Start],[Time5Stop],[UElapsed5],[DElapsed5],[Event_Code5],[Time6Start],[Time6Stop],[UElapsed6],[DElapsed6],[Event_Code6],[Time7Start],[Time7Stop],[UElapsed7],[DElapsed7],[Event_Code7],[Total_Up_Time],[Total_Down_Time],[Total_Time]) VALUES (#" & Date & "#, '" & TempVars!pvUserUser & "',#" & TempVars!pvMach_Area & "#, #" & Time1Start & "#,#" & Time1Stop & "#,# " & UElapsed1 & "#, # " & Time2Start & " #, # " & Time2Stop & " #, # " & UElapsed2 & " #,# " & DElapsed2 & " #, ' " & Event2 & "', # " & Time3Start & " #, # " & Time3Stop & " #, # " & UElapsed3 & " #, # " & DElapsed3 & " #, ' " & Event3 & " ', # " & Time4Start & " #, # " & Time4Stop & " #, # " & UElapsed4 & " #, # " & DElapsed4 & " #,
)"
Debug.Print ecSql

CurrentDb.Execute ecSql, dbFailOnError

Thanks.

[ssanfu]

This is how I split the lines:

    ecSql = "INSERT INTO 04Event_Collector ([Date_Collection],[User_Name],[Machine_Number],"
    ecSql = ecSql & " [Time1Start],[Time1Stop],[UElapsed1],[Time2Start],"
    ecSql = ecSql & " [Time2Stop],[UElapsed2],[DElapsed2],[Event_Code2],[Time3Start],[Time3Stop],[UElapsed3],[DElapsed3],[Event_Code3],"
    ecSql = ecSql & " [Time4Start],[Time4Stop],[UElapsed4],[DElapsed4],[Event_Code4],[Time5Start],[Time5Stop],[UElapsed5],[DElapsed5],"
    ecSql = ecSql & " [Event_Code5],[Time6Start],[Time6Stop],[UElapsed6],[DElapsed6],[Event_Code6],[Time7Start],[Time7Stop],[UElapsed7],"
    ecSql = ecSql & " [DElapsed7],[Event_Code7],[Total_Up_Time],[Total_Down_Time],[Total_Time]) "
    ecSql = ecSql & " VALUES (#" & Date & "#, '" & TempVars!pvUserUser & "',#" & TempVars!pvMach_Area & "#, #" & Time1Start & "#,#" & Time1Stop
    ecSql = ecSql & "#, #" & UElapsed1 & "#, #" & Time2Start & "#, #" & Time2Stop & "#, #" & UElapsed2 & "#, #" & DElapsed2 & "#, '" & Event2
    ecSql = ecSql & "', #" & Time3Start & " #, #" & Time3Stop & "#, #" & UElapsed3 & "#, #" & DElapsed3 & "#, '" & Event3 & "', #" & Time4Start
    ecSql = ecSql & "#, #" & Time4Stop & "#, #" & UElapsed4 & "#, #" & DElapsed4 & "#,)"

BTW, you have an extra comma before the last closing parenthesis.