Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Feb 26 18:04:19 CST 2007
Kath: I need them to be able to either add to or replace the value. This is a continuous form, BTW. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti Sent: Monday, February 26, 2007 2:56 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Increment or replace? Rocky - couldn't you assume the + sign as the default? Only subtract IF they enter a minus sign? Kath ----- Original Message ----- From: Rocky Smolin at Beach Access Software To: 'Access Developers discussion and problem solving' Sent: Tuesday, February 27, 2007 9:42 AM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.4/702 - Release Date: 2/25/2007 3:16 PM