Cant add any more controls to my form

[Guest]

I have a form with many (a lot!!) controls.

Now I have apparently hit the limit and I cant add any more controls. Even
after deleting some old controls I cant add new ones.

How do "compact" my form so that I can add new controls?

I tried renaming - as suggested by Access when displaying the message about
not allowing me to add a control - but without success.

 

[Jeff Boyce]

Diane

Try using Compact & Repair for the whole .mdb file.

If you have added a large number of controls, you might be able to get the
same job done with fewer controls if you can redesign the form. Feel free
to post a description of what you are trying to accomplish and see if any of
the newsgroup readers can offer alternate approaches...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Douglas J. Steele]

Unfortunately, you can't reset the counter for forms.

Create a new form, select everything from the old form and copy it, then
paste it on the new form. Don't forget to copy the code as well! Sometimes
when you do this, the code and the events don't get linked properly (i.e.:
you'll have code for, say, the Click event of a control, but the Click
property for the control won't indicate that there's an [Event Procedure]
linked to it). Take a look at my March, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access" for a fix for that problem. You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Guest]

I just copied the form and thereby gave it a new name - then I could do what
I wanted to do. Before I renamed by simply changing the form name - bat was
apparently not enough.

In this case I wanted a group of controls to be put in a sub-form as I then
believe I have room for many more controls.

My form shows data for a "solution" - and as I find more relevant solution
parameters, I add controls to the form. Hence the need for a large number of
controls.

--
Diane

Unfortunately, you can't reset the counter for forms.

Create a new form, select everything from the old form and copy it, then
paste it on the new form. Don't forget to copy the code as well! Sometimes
when you do this, the code and the events don't get linked properly (i.e.:
you'll have code for, say, the Click event of a control, but the Click
property for the control won't indicate that there's an [Event Procedure]
linked to it). Take a look at my March, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access" for a fix for that problem. You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a form with many (a lot!!) controls.

Now I have apparently hit the limit and I cant add any more controls. Even
after deleting some old controls I cant add new ones.

How do "compact" my form so that I can add new controls?

I tried renaming - as suggested by Access when displaying the message
about
not allowing me to add a control - but without success.

 

[Guest]

What, exactly is a solution? Are we talking Chemistry, Criminology, Process
Analysis, or what?

The approach you are describing indicates the design could be improved.
Rather than a new control for a new relevant solution, you may want to
consider combo or list boxes to allow data selection. It is much easier to
add a new record to a table to add a new value in a combo or list than it is
to modify your form. Also, a form with that many controls is going to be
confusing for a user.

I just copied the form and thereby gave it a new name - then I could do what
I wanted to do. Before I renamed by simply changing the form name - bat was
apparently not enough.

In this case I wanted a group of controls to be put in a sub-form as I then
believe I have room for many more controls.

My form shows data for a "solution" - and as I find more relevant solution
parameters, I add controls to the form. Hence the need for a large number of
controls.

--
Diane

Unfortunately, you can't reset the counter for forms.

Create a new form, select everything from the old form and copy it, then
paste it on the new form. Don't forget to copy the code as well! Sometimes
when you do this, the code and the events don't get linked properly (i.e.:
you'll have code for, say, the Click event of a control, but the Click
property for the control won't indicate that there's an [Event Procedure]
linked to it). Take a look at my March, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access" for a fix for that problem. You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a form with many (a lot!!) controls.

Now I have apparently hit the limit and I cant add any more controls. Even
after deleting some old controls I cant add new ones.

How do "compact" my form so that I can add new controls?

I tried renaming - as suggested by Access when displaying the message
about
not allowing me to add a control - but without success.