Stop MS Access auto rounding currency fields?

Question

Hi

This sounds really silly, but I can't seem to get Access to stop rounding up a Currency Field.

For example, if I enter 0.79p it rounds it up to £1.

Does anyone know how I can disable the Auto Rounding?

Thanks

Adam

Answer 1

I recommend that you do one of the following:

a. Change the Decimal Places to 2 if needed.

b. Format the field as Double.  That will retain the decimal places as is.