[AccessD] Unbound numeric textbox reverts to scientific notation

Gustav Brock gustav at cactus.dk
Wed Sep 11 02:31:19 CDT 2013


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




More information about the AccessD mailing list