A2K - 754 number of control limit reached on form

How can I reset this count? My form is stable now and doesn't have many
controls on it, though obviously it's seen alot of deletions as the form has
evolved and this contributes to reaching the 754 limit.

I have tried exporting to another database and then importing it back with
no luck.

I'm testing an add-on that applies a spiffy effect to command buttons and it
reports the 754 error on this particular form.


thanks

re: A2K - 754 number of control limit reached on form

On Oct 30, 4:20*pm, "Deano" <de...@mailinator.comwrote:Have you tried?

SaveAsText acForm, "Name of Form", "Temp.Txt"
SaveFromText acForm, "New Name for Form", "Temp.Txt"

and checked out the number of controls on the new form.

Really smart guys and gals would experiment with this on a copy of the
form or a copy of the database.

re: A2K - 754 number of control limit reached on form

On Oct 30, 6:45*pm, lyle fairfield <lyle.fairfi...@gmail.comSHOULDA
wrote:

Have you tried?

SaveAsText acForm, "Name of Form", "Temp.Txt"
LoadFromText acForm, "New Name for Form", "Temp.Txt"

and checked out the number of controls on the new form.

Really smart guys and gals would experiment with this on a copy of
the
form or a copy of the database.

re: A2K - 754 number of control limit reached on form

have you been compacting your db as you work on it? if not, you should do it
frequently during development - whether or not it fixes your current form
issue. also, have you tried creating a new blank form, then opening the
problem form in Design view, pressing Ctrl+A to select all objects, then
Ctrl+C to copy them. then open the new form in Design view and press Ctrl+V
to paste. if you have code in the problem form's module, you'll need to
highlight and copy it, then paste into the new form's module. delete the old
form, then compact the db, then rename the new form and compact again.

and before you do any of the above, make sure the Name Autocorrect option is
turned OFF. in the database window, from the menu bar select Tools | Options
| General tab.

hth


"Deano" <deano@mailinator.comwrote in message
news:490a174c$0$10551$db0fefd9@news.zen.co.uk...hasit

re: A2K - 754 number of control limit reached on form

1 ) open form in design mode, and then go file->save-as, and give the form a
new name.

2 ) delete original form, and rename the form from above to the original
form name...

The above will re-set the object count for the form...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

re: A2K - 754 number of control limit reached on form

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.comwrote in message
news:7V8Pk.29884$nl3.12855@newsfe01.iad...aJust got round to revisiting this form and bizarrely, nothing I do fixes
this. Tried your solution, then Tina's but I keep getting the error. I'm
going to cry...

re: A2K - 754 number of control limit reached on form

Probably a control that runs wild. Did you try to selectively start
deleting elements from this one form (of course you should make a backup
before ;-) ).?

Found several weird issues with all sorts of Acc that cannot be
explained (other than from inside MS-Access developers debugger). The
error messages sometimes lead you totally wrong.

I believe in your case any strange side effect will produce this.

rob*

Deano wrote:

re: A2K - 754 number of control limit reached on form

"Robert S." <robsmiler@googlemail.comwrote in message
news:491A8C16.8070201@googlemail.com...Thanks I'll give that a go when I'm next able but I'm thinking about
rebuilding the form from scratch. It has an ActiveX control that I want to
remove and replace with new code.

re: A2K - 754 number of control limit reached on form

"Deano" <deano@mailinator.comwrote
Did you try Lyle's suggestion? It has worked for me.

Larry Linson
Microsof Office Access MVP