Hi,
Office 365
I suspect a bug or corruption but compacted & repaired, re imported form etc
so wonder if something else
Me!PairDiscount is fixed 0.00 field on Main form
Me.Prices.Form!Pairing2Disc is fixed 0.00 field on subform
both bound to different tables. they are defined as double in both tables
manually typed & test via VBA so 25.7 (exactly) in the subform field.
Me!PairDiscount = Me.Prices.Form!Pairing2Disc
Debug.Print Me!PairDiscount & " : " & Me.Prices.Form!Pairing2Disc
25.7000007629395 : 25.7
if I put 25.8 I get 25.799923434 approx.
Just don't get it !!
If corruption seems odd but the only thing I can think. I can use Round but would like to know why.
Any ideas
Office 365
I suspect a bug or corruption but compacted & repaired, re imported form etc
so wonder if something else
Me!PairDiscount is fixed 0.00 field on Main form
Me.Prices.Form!Pairing2Disc is fixed 0.00 field on subform
both bound to different tables. they are defined as double in both tables
manually typed & test via VBA so 25.7 (exactly) in the subform field.
Me!PairDiscount = Me.Prices.Form!Pairing2Disc
Debug.Print Me!PairDiscount & " : " & Me.Prices.Form!Pairing2Disc
25.7000007629395 : 25.7
if I put 25.8 I get 25.799923434 approx.
Just don't get it !!
If corruption seems odd but the only thing I can think. I can use Round but would like to know why.
Any ideas