how can I break this into multiple lines

[hal12b]

How can I break this into multiple lines to avoid so much horizontal scrolling on my screen?


strQuery = "Update tblBrokerRegistration set FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, REP_NAME=@REP_NAME, MAILING_LIST=@MAILING_LIST, EMAIL_ADDRESS=@EMAIL_ADDRESS, USERNAME=@USERNAME, PASSWORD=@PASSWORD, ACTIVE=@ACTIVE, ROLE_LEVEL=@ROLE_LEVEL, LAST_UPDATED=@LAST_UPDATED WHERE ID=@ID"

[marcel]

You can do one of the following:

dim strQuery as String
strQuery = "UPDATE tblBrokerRegistration "
strQuery += "SET FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, "
strQuery += "ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, "
etc... etc...

or

dim strQuery as String
strQuery = "UPDATE tblBrokerRegistration " & _
 "SET FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, " & _
"ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, " & _
etc... etc...

[hal12b]

Thanks Marcel. #2 seems a little easier and it worked fine.