Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jan 23 17:17:28 CST 2012
That doesn't reflect the "lifetime count", only the number of controls currently on the form - excluding any previously created and deleted controls. On 23 Jan 2012 at 17:05, Gary Kjos wrote: > This code from here > > http://www.access-programmers.co.uk/forums/showthread.php?t=211166 > > will supposedly count your controls > > Private Sub cmdCountControls_Click() > Dim ctl As Access.Control > Dim lngCount As Long > > For Each ctl In Me > lngCount = lngCount + 1 > Next ctl > > MsgBox lngCount ' << 219 on the Form I tested it on. > > End Sub > > On Mon, Jan 23, 2012 at 3: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 > > > > -- > Gary Kjos > garykjos at gmail.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg