Subform not showing what I keyed in...

[PeteJohnston]

I've got a subform that allows me to key in payments received against an invoice. It shows four columns: Invoice text, invoice amount, payment date and payment amount.

On several invoices I get things that show the payment amount correctly but when I move the cursor into the field it changes the value. One example was a payment of £8512.85 (exactly what I keyed in) which then shows up as 8512.8496 !

Anyone got an idea why this should be?

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[ZmrAbdulla]

Look into the field properties and set it to currency with required decimal points.
or to DOUBLE

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.