[AccessD] Unbound numeric textbox reverts to scientific notation

Gustav Brock gustav at cactus.dk
Wed Sep 4 02:39:02 CDT 2013


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