Max # of controls

Does anyone know what the maximum number of controls is for a single form in
VBA?
Currently, the control count of one form stands at 46 but it won't be much
longer.

Thanks in advance!

 

I have 578 on mine, and a bunch more are added at run time, so I think you
have a ways to go.

Randy Richardson
Hattiesburg, MS

 

I have a text entity form that adds a label and text box for each text in
the selection set at runtime. It could be hundreds if you select that many.
I've never heard of any limit. Though there might be, for all practical
purposes, you can do what you want.

 

WOW!
Can you post a screen shot of that??!?

--
Matt W

The difference between genius and stupidity is that genius has its limits.
| I have 578 on mine, and a bunch more are added at run time, so I think you
| have a ways to go.
|
| Randy Richardson
| Hattiesburg, MS
|
| | > Does anyone know what the maximum number of controls is for a single
form
| in
| > VBA?
| > Currently, the control count of one form stands at 46 but it won't be
much
| > longer.
| >
| > Thanks in advance!
| >
| > --
| > Matt W
| >
| > The difference between genius and stupidity is that genius has its
limits.
| >
| >
|
|

 

Thanks, guys.
So I'm going to assume that the only limiting factor will be system
resources (which shouldn't be a problem).

--
Matt W

The difference between genius and stupidity is that genius has its limits.
| I have a text entity form that adds a label and text box for each text in
| the selection set at runtime. It could be hundreds if you select that
many.
| I've never heard of any limit. Though there might be, for all practical
| purposes, you can do what you want.
|
| --
| ----
| Ed
| ----
| | > Just curious, but why in the world would you need 578 controls???
|
|

 

The controls are not all visible simultaneously, so I couldn't post an image
where you could count 578 controls.

-Randy

 

When you automate the detailing of equipment that has so many variables that
the number of possible different configurations is pretty much infinite, and
in the process making it as user-friendly as humanly possible, you can
easily use 578 controls.

-Randy