a Decimal field set to 15 decimal places and then put
that into Data Sheet View and provided the window is
wide enough I get all 15 decimals.
However if you want to Truncate a number you can use:
Rounddown(Value, 15)
However, do becareful in my experience Access has
always seemed to have at least intermittent problems
with handling and manipulating real values when
inputting into a database or extracting from a
database.
Good Luck
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
SPONSORED LINKS
| Microsoft access database | Database development software | Microsoft access development |
| Database management software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
