Charlotte Foust
cfoust at infostatsystems.com
Thu Jul 30 14:15:54 CDT 2009
It's quite true, although I don't recall the exact number. Both forms and reports have a limit on the number of controls that can be added over the entire life of the object. Build one, dump a bunch of controls on it and then cut them off and paste them back. Eventually, it won't work and you'll get an error. It's been around since the earliest versions. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, July 30, 2009 11:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows? I have never heard of this "255 maximum controls regardless of when" thing. I would not doubt the 255 max controls part, it is the tracking of old controls that I would doubt. But Access has done stranger things. I have no idea where it would store tracking for old deleted controls, however given the rename tracking stuff it is probably out there somewhere. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > Why didn't I think of that.... > > Max > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 30 July 2009 19:02 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows? > > Export it out to a text file, then import it back in to a new name. > Delete the old, rename the new back to the old name. That might break > the spell. > > John W. Colby > www.ColbyConsulting.com > > > David McAfee wrote: >> I have. >> >> I've even completely rebuilt it. I think it may be the form that is >> some > how >> corrupt. >> >> I remember reading somewhere that a form can only have 255 controls, >> even > if >> its over time (deleting controls, adding controls, deleting controls). >> I have redesigned this form for a department that didnt know what it >> was that they want five times. >> >> I'm wondering if this somehow could be an issue. >> >> I may have to rebuild the whole form...which sucks because it is very >> complex. :( >> >> David >> >> >> On Thu, Jul 30, 2009 at 1:50 AM, Max Wanadoo <max.wanadoo at gmail.com> > wrote: >>> David, >>> Try COPYING a list box that works and then change the attributes to >>> what you need. >>> That sometimes works. >>> >>> Max >>> >>> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com