Number formats in Access 2000

  Mike D 11:53 21 Oct 03

I am sure that the answer to this is so simple, but for the life of me I can't figure it out.

When entering numbers into a table in a database that i have created i cannot get decimal places to show, even though I have tried to force this by using "2 decimal places " and fixed decimal places. Not only does the decimal place not show, but the entry is rounded to the nearest whole number.

Please help before I lose what little hair I have left.


  Epoc 12:02 21 Oct 03

You need to set the Field Size to Double rather than decimal.

  Mike D 12:10 21 Oct 03


I knew you wouldn't let me down - and in record time.
Thanks muchly, I've tried it and it works1


This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5