How to write string query on multiple lines

[brandonio21]

Try something like this!

[code2=vbnet]dbQuery = "INSERT INTO customer (accountNumber, nameLAST, nameFIRST, nameCOMPANY," & _
"addressSTREET, addressSTREET1, addressCITY, addressSTATE, addressZIPCODE, phone, fax, email)" & _
"VALUES('" & TextBoxAccount.Text & "','" & TextBoxLastName.Text & "','" & TextBoxFirstName.Text & _
"','" & TextBoxCompanyName.Text & "','" & TextBoxAddress1.Text & "','" & TextBoxAddress2.Text & "','" & _
TextBoxCity.Text & "','" & ComboBoxState.SelectedItem & "','" & MaskedTextBoxZip.Text & "','" & _
MaskedTextBoxPhone.Text & "','" & MaskedTextBoxFax.Text & "','" & TextBoxEmail.Text & "')"[/code2]

Basically, you just put a _ on the end of every line!