Re: Two many controls

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Graham R Seach (gseach_at_NOSPAMpacificdb.com.au)
Date: 10/26/04 

Date: Wed, 27 Oct 2004 01:09:37 +1000

Oded,

The problem is probably more a matter of a large number of control changes
being made to the form. You see, Access 2003 will only allow you to add 754
controls to a form over the lifetime of the form. I don't recall the limit
for previous versions. For example, if you were to add a textbox to an
Access 2003 form, then delete it, then repeat the same process 754 times,
Access would complain that you have too many controls on the form.

To get around this problem, create a new database, and import the offending
form into it. If you want, you can then delete the form from the original
database, compact, then re-import the form.

Mind you, if you have a truckload of controls on a form, I'd be looking at
your design. I've never seen a user interface where large numbers of
controls are actually necssary. No user could take in that much information
at one time anyway, so the rule is, KISS.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Oded Kovach" <roygoldh@hotmail.com> wrote in message
news:uEjFzY2uEHA.1520@TK2MSFTNGP11.phx.gbl...
> Hello there
>
> I have form that i've place on it two many controls
>
> As a result of that i can't use it anymore. when i open it for design,
> view
> or even delete it the access is going out.
>
> what can i do
>
> any help would be useful
>
>

Relevant Pages

  • Re: A simple employee class : OOP Study
    ... If you design a ... Broker that feeds objects from the database on an "as required" basis, ... around connecting visual controls to objects and/or list of objects. ... Joanna Carter ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: The Zen nature of a Delphi database application
    ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
    (comp.lang.pascal.delphi.misc)
  • Re: Max Controls on a Single Form.
    ... Normalization and good Database Design methodology. ... Database Design for Mere Mortals by Michael Hernandez ... -- --Roger Carlson www.rogersaccesslibrary.com Want answers to your Access questions in your Email? ... So a total of> 2000 seperate controls. ...
    (microsoft.public.access.forms)
  • Re: GUI for access application
    ... Can I do this in VBA? ... though it won't be easy unless you are familiar with database ... design, user interface design, VBA and SQL. ... tremendously powerful data-aware forms and controls built in. ...
    (microsoft.public.access.gettingstarted)
  • RE: Adding controls to a form with code
    ... isn't a good idea to be changing the design of forms at runtime. ... possible controls and setting each control's Visible property or Caption ... If you send me your E-mail address, I can send you an Access 97 database ... permissions to not allow regular users to modify that particular form, ...
    (microsoft.public.access.formscoding)