[AccessD] Unbound numeric textbox reverts to scientific notation

Charlotte Foust charlotte.foust at gmail.com
Wed Sep 11 12:53:24 CDT 2013


Gustav,

I suspect it is a precision issue.  Have you tried changing the datatype to
a double and using the format property to set the currency look?

Charlotte


On Wed, Sep 11, 2013 at 12:31 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Darryl
>
> Yes, that could work.
> Still, I find it strange that a value formatted as currency should appear
> in
> scientific notation - which is seen nowhere else.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af Darryl Collins
> Sendt: 11. september 2013 09:02
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Unbound numeric textbox reverts to scientific notation
>
> One possible solution would be enter the 'number' as a string/text in the
> form and convert it back to a numeric format upon save/write to the data
> table.  That would work, but also introduces some risks you would have to
> handle.
>
> Cheers
> Darryl
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Wednesday, 11 September 2013 4:48 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Unbound numeric textbox reverts to scientific
> notation
>
> Hi all
>
> So no solution or workaround to this?
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
> Sendt: 4. september 2013 09:39
> Til: 'Access Developers discussion and problem solving'
> Emne: [AccessD] Unbound numeric textbox reverts to scientific notation
>
> Hi all
>
> I noticed this question on Experts-Exchange but found, that I can't figure
> it out:
>
> I have an unbound form. One text box is for currency data (euros) which is
> great provided the user only uses up to 11 digits.
> Now, the limit for currency values is 922,337,203,685,477 i.e. fifteen
> digits, but as soon as a user enters more than 11 digits and moves the
> focus
> away from the field and then back, the text box reverts to scientific
> notation.
> <snip>
>
> I can replicate this but found that it is not related to neither Euro nor
> Currency; as soon as you apply some numeric format, you'll see this
> behaviour.
> Is there any way around it?
>
> I've only tested with A2010.
>
> /gustav
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list