[AccessD] Increment or replace?

Text property.  THAT'S what I was looking for.  Works perfectly.

Thanks Gustav.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, February 27, 2007 10:31 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Increment or replace?

Hi Rocky

You would need to use the Text property of the Textbox to get the entered
string.
Property Value is the store value.

/gustav

>>> rockysmolin at bchacc.com 27-02-2007 19:21:56 >>>
Gary:

No, the "+" sign is not part of the input. Access is stripping it off. 

I entered +50 and in the before update event tried both 

MsgBox Left(Me.QuantityDue, 1) 

and   

MsgBox Left(Trim(str(Me.QuantityDue)), 1) 

and both printed 5.

Rocky


--
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/703 - Release Date: 2/26/2007
2:56 PM