Max Controls on Form

  • Thread starter Thread starter KRose
  • Start date Start date
K

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

--
 
Have you tried to compact your database?
That many controls sometimes raises a red flag regarding table structures.
 
KRose said:
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)?
Click to expand...


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 said:
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
Click to expand...

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

--
 
KRose said:
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

--
Click to expand...

I can't really comment without having actually seen the form, but are you
sure that it's all that usable?
 
Rob said:
I can't really comment without having actually seen the form, but are
you sure that it's all that usable?
Click to expand...

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
--
 
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
 
Back
Top