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

Gary Kjos garykjos at gmail.com
Mon Jan 23 17:05:59 CST 2012


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


More information about the AccessD mailing list