Rocky Smolin
rockysmolin at bchacc.com
Tue Nov 2 12:30:39 CDT 2010
I'm sure it works there. I've never had this problem with a NotInList before. Very strange. I put the Undo in as well - but that's only if the user declines to add the value - doesn't affect adding it to the table. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, November 02, 2010 10:08 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Not In List Event Hi Rocky Strange. It works here - and doubles don't have leading zeroes ... And inserting the Undo as mention by Jürgen corrected a cancelled entry in the combo. /gustav >>> rockysmolin at bchacc.com 02-11-2010 17:48:28 >>> Ah, yes. Forgot that. But now, since there's no way to get that leading zero in there, every value I enter gives the error message. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, November 02, 2010 9:31 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Not In List Event Hi Rocky Yes. If you wish to display and enter percentage, you will have to enter percentage as 1.7 or 1.70, not 0.017. /gustav >>> rockysmolin at bchacc.com 02-11-2010 17:19:27 >>> Gustav: Changing to dblNewVal = Val(NewData) / 100 and entering 0.017 gives .00017. dblNewVal is too small by factor of 100 now. Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com