Line Break

[DS]

I can't seem to break this into two lines...also is there a better, or
shorter way to code this?
Thanks
DS

Me.TxtNone = Round(IIf(CDTaxCodeID = 2,
Nz(DSum("(CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP",
"CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND
CDTaxCodeID = 2"), 0), _
Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = " &
Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"), 0),
1))

 

[Klatuu]

What do you mean, break it into two lines?

 

[DS]

I want the code to be on two seperate lines.
Thanks
DS

 

[Klatuu]

You have a line continuation character _
already in the code. Are you getting an error?
Can you provide more detail, please?

 

[DS]

A short version,
Me.TxtField = DSum("Field","tblAll") + DSum("Field","tblSome")

This is too long so to view so I want to put the DSums on seperate lines.

Me.TxtField = DSum("Field","tblAll")
+ DSum("Field","tblSome")

How would I do this?
Thanks
DS

 

[Klatuu]

Me.TxtField = DSum("Field","tblAll") _
+ DSum("Field","tblSome")

But I still don't see the problem with the long version. As I said, you
already have the line continuation character.

I can't very well help if you wont say what the problem is.

 

[DS]

The second line is in red....
Thank
DS

 

[Klatuu]

Syntax is incorrect. See if this works.

Me.TxtNone = Round(IIf(CDTaxCodeID = 2,
Nz(DSum("CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP",
"CDCheckID = " & Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND
CDTaxCodeID = 2"), 0), _
Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = " &
Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"), 0),
1))

 

[DS]

Thanks
Still In Red.
DS

 

[Klatuu]

Me.TxtNone = Round(IIf(CDTaxCodeID = 2, _
Nz(DSum("CDQuantity*CDFinalPrice)/(1+CDTaxRate)", "tblCheckDetailsTMP", _
"CDCheckID = " & Forms!Form2!TxtCheckID & _
" AND CDDiscountDP = 0 AND CDTaxCodeID = 2"), 0), _
Nz(DSum("CDQuantity*CDFinalPrice", "tblCheckDetailsTMP", "CDCheckID = "
& _
Forms!Form2!TxtCheckID & " AND CDDiscountDP = 0 AND CDTaxCodeID <>2"),
0), 1))