[RESOLVED] Breaking A Long Line Of Code Into Segments

[SeanK]

This works like a champ is I have it all on one line, but it is also very difficult to read.

lngTotalPolicy = Val(adoRS.Fields.Item("tot_liab_paid_bal").Value) - Val(adoRS.Fields.Item("prior_bal").Value) - Val(adoRS.Fields.Item("incurred_debt").Value) - Val(adoRS.Fields.Item("fund_balance").Value)

But, nothing I've tried to put it on separate lines have works. This was my lastest failure

lngTotalPolicy = Val(adoRS.Fields.Item("tot_liab_paid_bal").Value) & _
-Val(adoRS.Fields.Item("prior_bal").Value) & _
-Val(adoRS.Fields.Item("incurred_debt").Value) & _
-Val(adoRS.Fields.Item("fund_balance").Value)

How can I put this line (which, obviously, is a calculation) on multiple lines so it is easier to read and understand, and still have it work?