[AccessD] max number of controls

...I do the tab/subform thing automatically myself ...but as Charlotte
pointed out, I hit it in a report where I was trying to be a bit fancy with
lines and such ...once you hit it, the form/report is simply dead, nothing
you can do but create a new form ...drove me bonkers the first time until I
found a reference to it on Dev's site :(

William Hindman
<http://www.freestateproject.org> - Do you want liberty in your lifetime?


----- Original Message ----- 
From: "John Colby" <jcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, October 27, 2003 12:22 PM
Subject: RE: [AccessD] max number of controls


> Nope, never ran into it.  I tend to do tabs / subforms so I wouldn't run
> into it in forms.
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
> Foust
> Sent: Monday, October 27, 2003 12:10 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] max number of controls
>
>
> John,
>
> Do you honestly mean you've never run up against that limitation?  It's
> been built into Access forever.  Try laying out a report complete with
> lines and graphics and you can run into it very quickly, since it
> applies to reports as well.   Compact has no effect on it.  The only
> cure is to create a new form and paste the controls onto it.  The
> limitation still exists, but you don't have all those deleted items
> messing you up.  It includes *every* control, including the bound
> labels, lines, boxes, buttons, pagebreaks, etc.
>
> Charlotte Foust
>
> -----Original Message-----
> From: John Colby [mailto:jcolby at colbyconsulting.com]
> Sent: Sunday, October 26, 2003 8:08 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] max number of controls
>
>
> >Access has a built in limitation of 754 controls that can be added over
>
> >the
> lifetime of a form
>
> Holy crap Batman, where do you find THAT?  And compact doesn't clean
> that up eh?
>
> Sometimes I can't believe what a POS we develop in.  8-(
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William
> Hindman
> Sent: Sunday, October 26, 2003 11:03 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] max number of controls
>
>
> Pedro
>
> ...it's not necessarily the number of controls currently on your form
> ...Access has a built in limitation of 754 controls that can be added
> over the lifetime of a form ...so even if your form currently has only
> 20 controls on it, if you've added and deleted controls frequently over
> its lifetime, you'll most likely have to recreate the form ...HTH :)
>
> William Hindman
> <http://www.freestateproject.org> - Do you want liberty in your
> lifetime?
>
>
> ----- Original Message -----
> From: "Pedro Janssen" <pedro at plex.nl>
> To: <AccessD at databaseadvisors.com>
> Sent: Sunday, October 26, 2003 6:02 AM
> Subject: [AccessD] max number of controls
>
>
> > Hello Group,
> >
> > is there a maximum number of controls that i can use on a form ( i get
>
> > an error, maximum number of controls reached). Is there a way to go
> > round
> this,
> > or can i better not use that many controls on one form and why?
> >
> > Pedro Janssen
> > Cytologist
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>