Hollis,Virginia
HollisVJ at pgdp.usec.com
Fri Mar 19 07:34:44 CST 2004
I set the Allow Zero Length to Yes & it still requires an entry. Do I have to do this for every table? -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Friday, March 19, 2004 7:07 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Don't want a required entry Virginia, Allow Zero Length may be your problem, try setting this to Yes. Paul Message date : Mar 19 2004, 12:57 PM >From : "Hollis,Virginia" To : "'accessd at databaseadvisors.com'" Copy to : Subject : [AccessD] Don't want a required entry What makes a table require an entry? I do not have any of the fields in the table set to Required. When I set up the tables, I used the Enforce Referential Integrity - I removed this thinking it was the problem, but it did not make a difference. For example, when I enter a request, I enter a requestor, but do not want to enter the name of the buyer because the requestor will not know who it will be assigned to. It will not let me move to another record unless I enter the name of the buyer. Any ideas? Virginia -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com