Charlotte Foust
charlotte.foust at gmail.com
Mon Jan 23 16:20:46 CST 2012
Didn't we just have this discussion a few weeks ago? As far as I know, you can't determine how many have been added. The number is stored internally is some arcane form that on Access sees. Ordinarily, well designed forms (which means you don't put everything on a single form) don't hit the limit ever. If you do hit the limit, one cure is to create a new form and copy and paste the controls and code from the old form, then renaming the old and new forms as needed. One suggestion made in our last discussion of this was to save the maxed out form to a text file and then import it into a new form in Access. That will certainly work with the code, but I've never tried more than that. Charlotte Foust On Mon, Jan 23, 2012 at 1:32 PM, Brad Marks <BradM at blackforestltd.com>wrote: > All, > > I noticed that there is a maximum of 754 controls that can be added over > the lifetime to a form. > > I understand how to determine how many controls are currently on a form, > but I don't understand how a person can discern how many have been added > "over the lifetime" of the form. > > Also, if a Form hits this limit, is there an easy way to deal with this > issue? > > Thanks, > > Brad > > PS. I tried a search on the AccessD archives but hit a snag. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >