Max Controls on Form

[KRose]

Hello,

After some research I have found the maximun number of controls for the
life of a form is 754.

I do not currently have 754, but I have added and deleted a number of
controls and have reached that "magic" number apparently.

I am getting the message: "Microsoft Access can't create any more
controls on this form or report."


Is there any way to reset or reclaim the unused control number, so I
can add a few more (once again the total will not exceed 754)?

Thanks in advance,

Kevin

--

 

[Duane Hookom]

Have you tried to compact your database?
That many controls sometimes raises a red flag regarding table structures.

 

[Marshall Barton]

After some research I have found the maximun number of controls for the
life of a form is 754.

I do not currently have 754, but I have added and deleted a number of
controls and have reached that "magic" number apparently.

I am getting the message: "Microsoft Access can't create any more
controls on this form or report."


Is there any way to reset or reclaim the unused control number, so I
can add a few more (once again the total will not exceed 754)?

I haven't seen this in a long time, nut I think maybe
Compacting the mdb might do it. If not, try Copy/Paste the
form (in the database window) and rename the old and new
copies. If all that fails to take care of it, create a
backup copy of your mdb, delete the form and use File Import
to get a fresh copy from the backup file.

 

[KRose]

Hello,

After some research I have found the maximun number of controls for
the life of a form is 754.

I do not currently have 754, but I have added and deleted a number of
controls and have reached that "magic" number apparently.

I am getting the message: "Microsoft Access can't create any more
controls on this form or report."


Is there any way to reset or reclaim the unused control number, so I
can add a few more (once again the total will not exceed 754)?

Thanks in advance,

Kevin

Thank you for the recommendations! I was using a lot of labels on the
form, so what I decided to do was use a screen capture tool to capture
the look to an image; now I am overlaying the "true" controls on top.

With the screen capture tool, the end-user will not be able to tell the
difference and I can manipulate the entire background at once.

Thanks for both of the replies.

Kevin

--

 

[Rob Oldfield]

Thank you for the recommendations! I was using a lot of labels on the
form, so what I decided to do was use a screen capture tool to capture
the look to an image; now I am overlaying the "true" controls on top.

With the screen capture tool, the end-user will not be able to tell the
difference and I can manipulate the entire background at once.

Thanks for both of the replies.

Kevin

--

I can't really comment without having actually seen the form, but are you
sure that it's all that usable?

 

[KRose]

I can't really comment without having actually seen the form, but are
you sure that it's all that usable?

Rob,

You make a very valid point; the answer is, I hope so. The form is
used primarily as a display page with the ability to add only three
pieces of data. The user wanted the existing data displayed on the
same form as the input (lefthand side of the form), so they could
easily compare with new data being input. I am using the image to
display the static items (a timeline), and filling in the dynamic items
on form load; allowing the user to add info on the righthand side of
the form.

Thanks for bringing this up.

Kevin
--

 

[John Moore]

You can copy the form to a new MDB file, compact that MDB, and then
copy the form back to the original MDB. That will "reclaim" whatever
controls may be remaining. I have used this often since I found
compacting the original MDB file did not always work.

TC