[AccessD] Not in List ... or Not?

Stuart McLachlan stuart at lexacorp.com.pg
Wed Mar 23 16:12:00 CST 2005


On 23 Mar 2005 at 12:54, GregSmith at starband.net wrote:

> My list has four(4) items in it.
> 
> So, why can I enter a BLANK in it?  A Blank is NOT one of my items in the
> list.  Last time I checked, when one says "limit to list", you should only
> be able to put in what's in the list.  Period.  End of sentence.  Nothing
> else.  Zip, zero, nada, nothin'.
> 
> I know I can check the field on exit to make sure it has something in it
> other than a blank (since the limit to list DOESN'T frickin' work right on
> blanks...), but I have about a gazillion other events happening with
> focusing and it hoses them up when it tries to go back.
> 

How about setting a Validation Rule of "NOT NULL"

-- 
Stuart





More information about the AccessD mailing list