Andy Lacey
andy at minstersystems.co.uk
Sun Jun 6 14:10:18 CDT 2004
I can confirm that Susan. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Susan Harkins > Sent: 06 June 2004 17:09 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] combo box Limit to List question > > > The Limit to List Property must be set to Yes for the > NotInList event to fire. At least, that's what Help says -- I > haven't actually tested it. > > Susan H. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jürgen Welz > Sent: Sunday, June 06, 2004 11:40 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] combo box Limit to List question > > I don't see how that is a problem because you can still add > to the list via the 'On Not in List' event. Wouldn't you > ordinarily just hide an AN to the first column and hide it > with a 0 width? This is my invariable approach and I use a > different combo backcolor to indicate whether the combo is > limited to list or provides add to list functionality. > > > Ciao > Jürgen Welz > Edmonton, Alberta > jwelz at hotmail.com > > > > > > >From: "Susan Harkins" <ssharkins at bellsouth.net> > > > >Here's one I've never run across before -- you can't set the Limit to > >LIst property to No if the control's bound column isn't > visible? Wow... > >that's a nasty little catch that could really be a clean up > mess if you > >weren't prepared for it. I've never run into it before. So, > if you want > >an updateable list, you have to display the bound column instead of > >whatever data you really want to display... nasty. :( > > > >Susan H. > > _________________________________________________________________ > MSN Premium: Up to 11 personalized e-mail addresses and 2 > months FREE* > http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994& DI=1034&SU=htt p://hotmail.com/enca&HL=Market_MSNIS_Taglines -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com