[AccessD] Increment or replace?

...I use a small popup calculator tied to the text box ...load the bound 
value into the calculator and allow the user to get to where he wants using 
the basic calculator functions ...when they hit enter, insert its current 
value into the record ...eliminates a lot of user data entry errors.

William Hindman

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, February 26, 2007 5:42 PM
Subject: [AccessD] Increment or replace?


> Dear List:
>
> I have a text box on a sub form bound to a numeric field which contains,
> obviously, a numeric quantity.
>
> If the user inputs a value in this box preceded by a '+' or '-' sign, I 
> want
> to add or subtract the value entered from the current value.  If they 
> enter
> a value without a preceding sign, I want to replace old the value with the
> input value.
>
> I can obviously see if they entered a minus sign because the number is
> negative.  But how can I know if they preceded the input value with a '+'?
>
> MTIA
>
> Rocky
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>