av8tordude
01-17-2011, 12:14 PM
This code is subtracting one value with another, but if the results are negative, how can I display the value as $0.00?
frmPDCalc.DL8B.Caption = Format(CCur(Replace(Replace(frmPDCalc.EL6B.Caption, "$", ""), ",", "")) - CCur(Replace(frmPDCalc.Test7B.Caption, "*", "")), "$##,###0.00")
frmPDCalc.DL8B.Caption = Format(CCur(Replace(Replace(frmPDCalc.EL6B.Caption, "$", ""), ",", "")) - CCur(Replace(frmPDCalc.Test7B.Caption, "*", "")), "$##,###0.00")