Out of Memory Error

[business_analyst]

Hello All,

So I've created a form that has literally 1200 Textboxes. After creating this, I tried to access the code, but when I attempted to do so I got a message prompt that says "out of memory". This prompt also occurs when I try to compile and run the form. Is there a way around this prompt? or is this due to the number of textboxes on my form?

 

[shg]

If you export the form module, how large is it? If >64K, that may be the source of the problem.

 

[RoryA]

Why do you want a form with that many textboxes? From a user standpoint, it must be horrible, I'd have thought.

 

[business_analyst]

thanks i've decided to split the number of textboxes in half and put them on separate forms. This has solved the "out of memory" issue. And yes, i would imagine it will be horrible from a user standpoint. I tried to make that point with the end user, but this is how they requested it done.

 

[mikerickson]

I agree with Roy, how long would it take a user to fill in 1200 textboxes, no matter how many userforms they are spread about?
(Heck, how long would it take them to read 1200 textboxes?)