Gustav Brock
Gustav at cactus.dk
Tue Nov 2 12:08:24 CDT 2010
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