decimal display without rounding

[Steve in Procurement]

I need to set up a field in a table and form that displays a number to the
eighth decimal position. The display appears to round it to he 4th position,
which is no good. How can I get the full number to diplay? I've changed the
decimal settings, the format and field size to no avail. Anyone?

 

[Allen Browne]

The Decimal Places property only affects how the nubmer is displayed; it has
no effect on how it is stored.

When you open your table in design view, what is the Data Type of this
field?

If Currency, Access stores only 4 places after the decimal point.

If Number, then look at the Field Size property in the lower pane. If it
says Double, you have around 15 significant figures, whether those figures
are before or after the decimal point. Single is only half of that.

There is another Field Size called Decimal, where you can specify 28
significant digits (the Precision property), including 8 after the decimal
point (the Scale property.) Unfortunately, Microsoft got the implementation
of this data type wrong. You cannot even do a basic sort on this field, so
it is not recommended. Details:
http://allenbrowne.com/bug-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Steve in Procurement" <Steve in (e-mail address removed)>
wrote in message
news:[email protected]...