break a long sql vba statement into multiple lines

vba ms-access-2007

In VBA a space followed by underscore and nothing else after that gives you a line break.

e.g.

DoCmd.RunSQL "UPDATE INDIVIDUAL SET INDIVIDUAL.INDI_FIRSTNAME = '" & _prospect_contact!FirstName & "', INDIVIDUAL.INDI_LASTNAME = '" & _ etc

But don't break lines within a string literal: that is a syntax error.

There is a surprisingly small limit to the number of line breaks you can have.

CodeHunter