• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 773
  • Last Modified:

MS Access 2003 SubForm Limit

Is there a limit to the number of subforms in MS Access 2003?
I think I read somewhere it's 7...but what does that mean?

Does it mean that THIS would be the limit?
MainForm
SubForm1                                                                       Subform2        Subform3
SubForm1_1    SubForm1_2   SubForm1_3


Or THIS?
MainForm
SubForm1
     SubForm1
          SubForm1
               SubForm1
                    SubForm1
                         SubForm1
0
Larry Brister
Asked:
Larry Brister
  • 5
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
It means the 'Or THIS?"

Embedded = 7 max. Same for SubReports.

mx
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Three levels deep is it too...

Jim.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
ah just did a double check and that changed at some point from 3 to 7.  3 was the old limit for nested forms.

BTW, the other way (non-nested) is just a limit on resources available; I'm not aware of any limit there other then 754 controls over the lifetime of a form (which I'm thinking as I'm saying that, has changed as well to over 1200).

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
'over 1200'
really ... about time.  

wait ... this spec is still showing 754 ...

http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx

where did you see this ?

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<where did you see this ?>>

 I actually tested it.  With each release since A97, the number of controls has gone up.

I'll see if I can find the post...I may even have the DB I tested with lying around.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
OK found my old posts (it is from another developers list):

A2 - 653
A97 - 752
A2000 - 800
A2002 - 894
A2003 - 895
A2007 - 1040
A2010 - 1040

 So the current limit is not as high as I was thinking (1200), but it's 1040 which is well above the published spec.  

 Code that was used to check this is below.  Control type didn't seem to make a difference (I only tested labels and text controls though) as I got the same numbers each way.  This code was also run on multiple machines and verified by different people.  All got the same numbers.

 So apparently the control creation limit is not a hard limit, but based on some other internal constraint.  This is similar to the table ID limit, which is stated as 2048, but actually floats a bit.

  These limits are somehow tied to the way Access internally handles open objects, but what that process is is un-clear.

Jim.

Public Sub CheckControlCreation()

  Dim frm As Form
  Dim ctlText As Control
  Dim ctlLabel As Control
  Dim intK As Integer

  ' Create form based on Customers form.
  Set frm = CreateForm()

  For intK = 1 To 2000

    ' Create unbound default-size text box in detail section.
    Set ctlText = CreateControl(frm.Name, acTextBox, acDetail, , , 100 + intK, 100 + intK, 200, 200)

    ' Create child label control for text box.
    Set ctlLabel = CreateControl(frm.Name, acLabel, , ctlText.Name, "", 100, 100)
   
    Debug.Print ctlText.Name, ctlLabel.Name
 
  Next intK

End Sub
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
How funny ... imagine - a spec that Microsoft has wrong. I wonder how many others of off ?
Interesting difference between A2002 and A2003 .... one control.

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
I think the spec was written at the time of A95/A97 (that's when it first appeared), and has simply been carried forward without anyone really checking it.

Meanwhile, the process that's involved with the limit has evolved over time and allows more.  Whether that's by design or just a by-product of other changes is hard to say.

 Seems strange too that it's gone up in every release, so my guess it's a result of something else.

 and the really weird part; no where did we come up with 754!

Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now