i have many text box in this format ( 5,000.00) first one named (DP1)
but i want to sum them all to a textbox named ( sumDP )
but this box read only numbers before ( , ) from the left
so it's see only 5.00 not 5,000.000
i want to fixe it please
____
My code is
___
Private Sub DP1_Change()
For i = 1 To 1
Sum = Sum + Val(Me("dp" & i))
Next i
Me.SumDp.Value = Sum
Me.SumDp.Value = Format(Me.SumDp.Value, "#,##0.00")
End Sub
Bookmarks