[AccessD] Questions about the Maximum Number of Controls Added Over the Lifetime to a Form (Access 2007)

Gary,

Thanks.

Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Monday, January 23, 2012 5:06 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)

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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.