Re: Formatting large numbers
- From: "Graham Mandeno" <Graham.Mandeno@xxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 12:03:43 +1200
Hi Jeff
You have reached the limit of precision of the Double data type
(approximately 14-15 significant figures), so the result is being rounded.
Assuming these numbers are stored in a table, change the data type of the
field to Decimal, with a scale of 6 and a precision of at least 19 (more in
you want numbers greater that 10^13).
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
"Jeff" <Jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:602BAE5B-2635-457E-831D-8997CBFB90D4@xxxxxxxxxxxxxxxx
> Hello,
>
> I have a Text Box on a Form where the user can enter a ver large # (1
> Trillion and with 6 decimal places). But I am having trouble having it
> stay
> Formatted correctly when the user moves to another field. It keeps
> rounding
> to 2 decimal places.
>
> So for example if the user puts 1222333444555.123456 Access then makes it
> 1,222,333,444,555.120000.
> I want it to Format to 1,222,333,444,555.123456
>
> Or if
>
> I have set the Input Maske to 9999999999999.999999
> I have set the Deciaml Places Property to 6
> and I have played around with many different Formats, like:
> #,##0.000000
> #,##0
> #,###.######
>
> I even tried in the AfterUpdate Event using the CDEC function to convert
> it
> to Decimal but then leaves it in Scientific Notaion.
>
> Can someone please help me so that again it Formats to
> 1,222,333,444,555.123456 ?
>
> Also if I use a small er # like up to millions it works fine, I just run
> into this problem when I use very large #s.
>
> Any help would be greatly appreciated.
>
> Thank you,
> Jeff
>
.
- References:
- Formatting large numbers
- From: Jeff
- Formatting large numbers
- Prev by Date: Re: Form and subform
- Next by Date: Re: Counting only Yes values from a Yes/No field.
- Previous by thread: Re: Formatting large numbers
- Next by thread: Adding items to a list box
- Index(es):
Relevant Pages
|
