[AccessD] Not In List Event

Hi Rocky

Very well.
You can input, say, 0.77 for an entry of 0.77%.

Entering .77 or 08.3 can be considered bad behaviour of the user because such values would never exist on the list as they would be formatted to 0.77 and 8.30 respectively.

/gustav

>>> rockysmolin at bchacc.com 03-11-2010 17:33:09 >>>
Gustav:

Thanks so much for sending over that test mdb.  It still has the problem if
you enter an item not in the list which begins with a decimal point. And in
this version entering a number not in the list beginning with 0. also has
the problem.  

But if the user is going to enter percentages then they're not going to be
entering numbers less than 1.  So I think this will work around the problem.


Many Thanks.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, November 03, 2010 12:05 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Not In List Event

Hi Rocky

I'll zip my test db to you to study.

/gustav


>>> rockysmolin at bchacc.com 02-11-2010 18:55 >>>
Tried it but no change in behavior.

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:43 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Not In List Event

Hi Rocky

Did you set the format of the table field to Percent?

/gustav