Line Continuation

[dbalargin]

I have about 50 variables to insert into a table.
My code looks like: docmd.runsql "INSERT INTO ..."
Problem - I need to continue the line at a variable.
What do I do?

 

[WayneRyan]

dba,

DoCmd.RunSQL "Insert Into YourTable (FieldA, FieldB, FieldC) " & _
             "Values ('" & Me.FieldA & "', '" & _
                           Me.FieldB & "', '" & _
                           Me.FieldC & "')"

Wayne

 

[Rob.Mills]

Are you talking about using this as a line continuation? _

 

[dbalargin]

Thanks a bunch!