limit to # of forms in a db?

[Robbie]

Is there a limit to the number of forms you can add to a database? The reason I ask is all my forms started acting screwy when I went to add a new one. I deleted that form, got the rest to work again by eliminating an OnOpen event that had worked previously on all the forms. Then I went back to add the new form again and weird things started happening. I can't open the new form in Form view from Design view. I tried to cut and paste a logo from Word into an old form and it wouldn't paste in. So . . . is there a limited amount of space for forms?

Thanks!

Robbie

 

[Immanuel Sibero]

Hi Robbie

Per Access Help on "Specifications", the limit of Access objects (forms are
objects) is 32,768.


Immanuel Sibero

Is there a limit to the number of forms you can add to a database? The

reason I ask is all my forms started acting screwy when I went to add a new
one. I deleted that form, got the rest to work again by eliminating an
OnOpen event that had worked previously on all the forms. Then I went back
to add the new form again and weird things started happening. I can't open
the new form in Form view from Design view. I tried to cut and paste a logo
from Word into an old form and it wouldn't paste in. So . . . is there a
limited amount of space for forms?

 

[Robbie]

Well that's good to know. I'm nowhere near that. Turns out may be not enough memory in this computer as well as problem with Office not freeing up memory as I close things down.

Thanks for your response.