[AccessD] Unbound numeric textbox reverts to scientific notation

Charlotte Foust charlotte.foust at gmail.com
Thu Sep 5 13:12:58 CDT 2013


What happens if you make the control larger?  I don't normally use the
currency format but use standard instead.  I haven't had much luck with
currency except for smaller values.

Charlotte


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

> 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