[AccessD] Increment or replace?

I did this a different way a while back. I'll see if I can find the code, but it wasn't difficult. I trapped for the + and - keys and did the increment/decrement myself in code.

Arthur 


----- 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:25 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