Brad Marks
BradM at blackforestltd.com
Mon Jan 23 16:35:18 CST 2012
Charlotte, Thanks for the info. I sort of remember this discussion from a few weeks ago, but I wasn't fully paying attention at the time. Today, I started to think about this some more and decided to do some experimenting. I also tried to find the earlier discussion in the AccessD Archives but hit a snag. I have a form with about 10 tabs. Each tab has a number of buttons, etc. I have not been careful with adding and deleting buttons, so I would like to be able to see what the "Lifetime" number is for this form. I appreciate your advice on how to deal with the problem if the limit is reached. Thanks again, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, January 23, 2012 4:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Questions about the Maximum Number of Controls Added Over the Lifetime to a Form (Access 2007) 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 > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.