I have five unbound textboxes set to Standard, 2 decimal points.
The first four are populated with a Select query.
The fifth box sums the first four boxes for a Total.
The numbers appear correctly (amount and formatted) on the form as does the Total. For redundancy and error checking (due to the db being a mission critical financial database), I do this math...
If Not (Box1 + Box2 + Box3 + Box4) = Box5 Then MsgBox "Error"
(Box1 + Box2 + Box3 + Box4) equals 175000
Box5 Total equals 175000
(Box1 + Box2 + Box3 + Box4) - Box5 should equal zero
However, in my case, the difference is not zero but is -2.91038304567337 E-11.