[AccessD] Unbound numeric textbox reverts to scientific notation

Hi John

Both yes and no. The largest number has a 9 as the first digit but the remaining are not 9s, so you cannot just count the length. Also, typing a larger number than allowed doesn't raise an error, only forces the resulting number into scientific format and rounds it. So, I guess, you could compare the strings before and after update for a match; if no match, something has happened.

/gustav

>>> jwcolby at gmail.com 13-09-13 18:44 >>>
Simple is always better!

Can you specify the max size by stringing zeros on the front?

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 9/13/2013 12:31 PM, Gustav Brock wrote:
> Hi all
>
> It seems that you can handle this in a simple way by setting the format:
>
> Private Sub txtEuro_Enter()
>      Me!txtEuro.Format = "0.00"
> End Sub
>
> Private Sub txtEuro_Exit(Cancel As Integer)
>      Me!txtEuro.Format = "Euro"
> End Sub
>
> It doesn't validate for too large input but that can be arranged otherwise
> as needed.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
> Sendt: 11. september 2013 20:57
> Til: accessd at databaseadvisors.com
> Emne: Re: [AccessD] Unbound numeric textbox reverts to scientific notation
>
> Hi Charlotte
>
> OK, thanks. Then I guess there is no easy or elegant way to handle this.
>
> /gustav
>
>
>>>> charlotte.foust at gmail.com 11-09-13 20:07 >>>
> Ah, I missed the unbound part.  I've had similar experiences with unbound
> textboxes switching to scientific notation, and I believe I've resorted to
> using a string on the unbound box.
>
> Charlotte
>
>
> On Wed, Sep 11, 2013 at 11:02 AM, Gustav Brock <Gustav at cactus.dk> wrote:
>
>> Hi Charlotte
>>
>> No, if it is bound to a table with a field of data type Currency, it
>> would work.
>>
>> But this textbox is unbound.
>>
>> /gustav