Max Controls on Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KRose - 17 Dec 2005 19:11 GMT

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

Reply to this Message

Duane Hookom - 17 Dec 2005 19:39 GMT

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

Signature

Duane Hookom
MS Access MVP

> Hello,
>
[quoted text clipped - 13 lines]
>
> Kevin

Reply to this Message

Marshall Barton - 17 Dec 2005 19:46 GMT

>After some research I have found the maximun number of controls for the
>life of a form is 754.
[quoted text clipped - 7 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

KRose - 17 Dec 2005 22:26 GMT

> Hello,
>
[quoted text clipped - 13 lines]
>
> 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

Reply to this Message

Rob Oldfield - 17 Dec 2005 22:56 GMT

> > Hello,
> >
[quoted text clipped - 24 lines]
>
> Kevin

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

Reply to this Message

KRose - 18 Dec 2005 02:49 GMT

> > > Hello,
> > >
[quoted text clipped - 30 lines]
> 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

Reply to this Message

John Moore - 31 Dec 2005 17:25 GMT

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

>> > > Hello,
>> > >
[quoted text clipped - 45 lines]
>
>Kevin

Reply to this Message