If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
decimal display without rounding
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? |
#2
|
|||
|
|||
decimal display without rounding
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Steve in Procurement" Steve in wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
double vs. decimal | Jennifer | General Discussion | 10 | June 20th, 2005 05:56 PM |
WORD 2002 will not display ASPX clip files. | LOUISE | General Discussion | 1 | January 11th, 2005 07:58 PM |
rounding to 2 decimal places | mansur | Running & Setting Up Queries | 3 | June 8th, 2004 09:41 PM |
average rounding to 3 decimal places | Bernie Deitrick | Worksheet Functions | 0 | June 2nd, 2004 06:11 PM |
No Rounding - need full decimal value | JE McGimpsey | Worksheet Functions | 2 | March 10th, 2004 10:55 PM |