Bound field should be 25.7 but is 25.7000007629395 (1 Viewer)

[bignose2]

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

 

[Minty]

Have a read of this https://access-programmers.co.uk/forums/showpost.php?p=333267&postcount=11

 

[JHB]

What happen if you change it to currency instead of double, (in the table)?

Else post a small database with some fake data + the forms, main and subform.