[AccessD] Form Lifetime Control Limit (Was: Advice on A2010....)

>
> Jim Dettman:
>  The default control names may have something to do with it, but it's not
> the entire answer.  I just ran the code below in A2003 and was able to
> create 895 controls.   I tried the same code in other versions as well:
>
> A2000 - 800
> A2002 - 894
> A2007 - 1040
> A2010 - 1040
>

Very intriguing, Jim. I ran your code on Access 2000, and got 801 controls,
confirming your result.

A Google search revealed that the 754 limit is very widely quoted, and even
Microsoft's own page repeats this figure:
http://support.microsoft.com/kb/208192

But I have personally seen forms with this 754 control limit, however the
database was imported from Access 97.

So, I still think my theory stands -- but the numbers are correct only for
Access 97. Does anybody have an ancient version of Access 97 they can test
this on?

It is obvious that the control limit was raised in later versions of
Access, but the reasons for these particular limits remain mysterious.

-Ken