D
David W
I have got a text box that I am putting a calculation from vb in.
The problem I am having is that the numbers I am calculating apparently have
more than 2 numbers to the right of the decimal.
Is there a way to use the numbers that already exist and in the calculations
used in vb, set how many decimals to the right.
example
I have
Me.caltotal = Me.Text31 - Me.tempcost
If Me.caltotal = 0 Then
DoCmd.GoToRecord , , acNext
Else
MsgBox "my message", vbCritical + vbOKOnly, "Conflict in Cost"
Exit Sub
End If
I have all of the textboxes set to currency with 2 decimals
If I change the decimals on me.caltotal, I get like.0069 for a result.
Some will pass some won't, even the ones that say 0.00
The problem I am having is that the numbers I am calculating apparently have
more than 2 numbers to the right of the decimal.
Is there a way to use the numbers that already exist and in the calculations
used in vb, set how many decimals to the right.
example
I have
Me.caltotal = Me.Text31 - Me.tempcost
If Me.caltotal = 0 Then
DoCmd.GoToRecord , , acNext
Else
MsgBox "my message", vbCritical + vbOKOnly, "Conflict in Cost"
Exit Sub
End If
I have all of the textboxes set to currency with 2 decimals
If I change the decimals on me.caltotal, I get like.0069 for a result.
Some will pass some won't, even the ones that say 0.00