VBA Out of Memory

I've got a really big form (100s of objects on a multipage object). And I
added a few more objects, and now I get out of memory errors, am I running
up against some artifical boundary in VBA? Or is it my settings? I tried it
on a few computers and I get the same results so I'm thinking the former.

-Anthony F

 

It looks like it seems to error out at around 1208 objects (plus the form,
so 1209 is the max it seems - I used form.controls.count to figure it out).

-A

 

So you're saying, that if you delete one of the controls, down to 1207, you
don't get the error?

 

Correct. No matter how many lines of code I add or remove, if I delete one
control the error goes away.

-A

 

Instead of having all the controls on one form, have you thought about
multiple forms, e.g. a button that opens a subform?

 

Yea, I'm refactoring the form's layout now. Its more lines of code to
manage, but since I ran into the limit of how many objects I can have on one
form before I hit the limit of how many lines of code I can have in one code
segment, I'm going to add more code. Oh well, I'll prolly just rewrite it in
..net soon enough anyways...

-Anthony

 

Yea, I'm refactoring the form's layout now. Its more lines of code to
manage, but since I ran into the limit of how many objects I can have on one
form before I hit the limit of how many lines of code I can have in one code
segment, I'm going to add more code. Oh well, I'll prolly just rewrite it in
..net soon enough anyways...

-Anthony