[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