CONTROL LIMIT

[James]

How many controls am I allowed to have in one form? What are the
dangers of having too many controls in one form. Thanks.

 

[Guest]

Hi James

I don't think there is a limit. The dangers are - you will confuse users
with too many - it will be a badly designed form with too many.

Use F1 then search for "Specifications"

Good luck

 

[Ken Snell \(MVP\)]

Limit is 754 controls on a form.

 

[Guest]

LoL - you learn something new every day.

Thanks Ken

 

[George Nicholson]

.....and it's a LIFETIME limit. Deleted controls will continue to count
against the 754 limit even after a Compact & Repair. In other words, it
doesn't act like deleted fields vs the 255 field limitation (which makes
sense since C&R is a Jet function that deals primarily with data, and
controls aren't data). AFAIK the only way to "reset" the counter is to
create a new form & copy controls to it.

HTH,

 

[Larry Linson]

Limit is 754 controls on a form.

The limit of the human brain to grasp and use information is much, much
lower. And, as George pointed out, that is a "lifetime limit" for the Form.

The danger of exceeding it, in Access 2.0, which was the last time it
happened to me (in an inherited database) was that the form became
unrecoverably corrupted and had to be re-created from scratch... not a fun
thing, as it was "duplicating a paper form" for a detail-oriented user (note
I did not say 'nitpicker') and the form was multi-page, alignment was
important, and neatness counted.

It seems to me that I've heard another way to recover, but it did not seem
as easy as importing the controls and associated code into a new Form --
provided your Form doesn't become "unrecoverably corrupted" as that one did
for me.

Larry Linson
Microsoft Access MVP

 

[James]

The limit of the human brain to grasp and use information is much, much
lower. And, as George pointed out, that is a "lifetime limit" for the Form.

The danger of exceeding it, in Access 2.0, which was the last time it
happened to me (in an inherited database) was that the form became
unrecoverably corrupted and had to be re-created from scratch... not a fun
thing, as it was "duplicating a paper form" for a detail-oriented user (note
I did not say 'nitpicker') and the form was multi-page, alignment was
important, and neatness counted.

It seems to me that I've heard another way to recover, but it did not seem
as easy as importing the controls and associated code into a new Form --
provided your Form doesn't become "unrecoverably corrupted" as that one did
for me.

Larry Linson
Microsoft Access MVP

Thanks for the help, the counter confused me a bit. I might have to
rebuild from scratch. Thanks.

 

[David W. Fenton]

AFAIK the only way to "reset" the counter is to
create a new form & copy controls to it.

I'd use SaveAsText for that.

 

[David W. Fenton]

Limit is 754 controls on a form.

Can anyone explain the reason for that it being that particular
number?

 

[Ken Snell \(MVP\)]

Can anyone explain the reason for that it being that particular
number?

I can't.....I don't know.

 

[ksf123]

The limit of the human brain to grasp and use information is much, much
lower. And, as George pointed out, that is a "lifetime limit" for the
Form.

The danger of exceeding it, in Access 2.0, which was the last time it
happened to me (in an inherited database) was that the form became
unrecoverably corrupted and had to be re-created from scratch... not a fun
thing, as it was "duplicating a paper form" for a detail-oriented user
(note I did not say 'nitpicker') and the form was multi-page, alignment
was important, and neatness counted.

It seems to me that I've heard another way to recover, but it did not seem
as easy as importing the controls and associated code into a new Form --
provided your Form doesn't become "unrecoverably corrupted" as that one
did for me.

Larry Linson
Microsoft Access MVP