[AccessD] Unbound numeric textbox reverts to scientific notation

Hi Charlotte

That doesn't matter. 
If it is too narrow, however, it may be filled wish hash marks: #######.

/gustav

>>> charlotte.foust at gmail.com 05-09-13 20:12 >>>
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