control limit per form

[markjkubicki]

i am told that over the lifetime of a form there is a limit of 754 controls, and that this includes currently active controls, as well as those that had at one time been added, but had consequently been deleted, and no longer exist (?)



is this correct, and if so, is there a way to tell where I'm at in the count (I have a hunch I'm getting into that zone-ish ...maybe)

mark

[Beetle]

The first thing that comes to mind is what scenario requires that you need that many controls on a single form? This would be unusual. Not saying that it would absolutely be wrong, maybe you have a lot of unbound controls with scientific calculations, I don't know, but it is definitely unusual. Having said that, you can recover the deleted controls by doing a Compact & Repair. Alternatively, you could create another empty db, import your form there, delete the form from the real db, then import it back in. As far as determining the number of controls currently on your form, there is no built in way that I am aware of, but you could do it with some VBA (example air code);

Dim ctl As Control
Dim lngCount As Long

For each ctl in Me.Controls
    lngCount = lngCount + 1
Next ctl

Msgbox lngCount

[markjkubicki]

perfect big thanks

I'm attaching a few screen shots of the form with different tabs exposed, in case it spurs any other suggestions

I suspect that going forward (this is an ongoing continual evolution of a form...), as the opportunity presents, I'll start using more pop-up forms (fired from events on this one), rather than piling still more controls onto the already 436 controls on this main form...

again, thanks

[Beetle]

You could also use sub forms to help manage the number of controls. You could move some of these to another form, then place that as a sub form on one or more of the tabs on your tab control. If hide the borders of the sub form control you could make it look essentially the same as it does now. The only potentially difficult part might be if you have a lot of references to your form controls, either in code or in queries, you would need to modify the references for any controls that you move to a sub form.

[Gicu]

Hi Mark,
I have definitely hit that limit in the past in a multi-tabbed form used as a "template" for new clients; we would customize it by deleting some unused and/or hidden controls and adding new ones to match the new business requirements. When you hit the limit you'll know as you will encounter form corruption and the form will refuse to be "saved" . The way I sued to deal with this was to start with a new form in design view, the old form in design view and copy and paste all the controls by section (first the header, then the detail and lastly the footer) from the old to the new, set the new form and section properties (caption, navigation, back color, etc.) to match the old one, copy and paste the entire VBA form module, save the new form with a different name, delete the old form, compact and repair and finally rename the form with the old name (maybe one more compact and repair after this). I found that this approach always reset the available controls and I was able to save the form.

Cheers,
Vlad

[ArviLaanemets]

You can write an UDF, which counts the number of controls in some active form (on fly: the function gets form as parameter, defines Control's object for this form, and counts controls in this object).

Or you open the form in Design mode, activate it, and select Tab Order from menu. In opening popup window you can manually count all controls in form Header, Detail and Footer respectively. NB! Labels, Tab Control Pages etc. are left out!

[Gicu]

But that does not give you the cumulative number of controls that were on the form over its lifetime (https://social.msdn.microsoft.com/Fo...orum=accessdev).