sql update statements over several lines in vb

[Shokoth]

I also wanted to know how to spread out sql statement over 3 lines.

I am writing an sql update statment in VB.

I have about 12 fields to update.

[code]
strSQL = "UPDATE [tblServiceUserPayments]" & _
"Set [tblServiceUserPayments].[January Payment] = DateSerial(Year(Date()),1,30), [tblServiceUserPayments].[JanPaymentRec] = False, [tblServiceUserPayments].[February Payment] = DateSerial(Year(Date()),2,28), [tblServiceUserPayments].[FebPaymentRec] = False " & _
"WHERE ((([tblServiceUserPayments].JanPaymentRec)= True) " & _
"AND (([tblServiceUserPayments].FebPaymentRec)= True));"
[code]

i have 10 more commands like that, and was wondering if it could be spreaded over several lines instead of one long line?
i have tried a few things, but they presented errors.

[Shokoth]

If i put it in a different line, and put the word AND infront of it, the statement infront of the AND does not update, but the rest do

Is there any special characters that we need to use

[MMcCarthy]

Try this ...

strSQL = "UPDATE [tblServiceUserPayments]" & _
"Set [tblServiceUserPayments].[January Payment] = DateSerial(Year(Date()),1,30), " & _
"[tblServiceUserPayments].[JanPaymentRec] = False, " & _
"[tblServiceUserPayments].[February Payment] = DateSerial(Year(Date()),2,28), " & _
"[tblServiceUserPayments].[FebPaymentRec] = False " & _
"WHERE ((([tblServiceUserPayments].JanPaymentRec)= True) " & _
  "AND (([tblServiceUserPayments].FebPaymentRec)= True));"