Weird Form Control Problem

[MWB]

Hey guys,



I have a data entry form with probably around 400 controls. From my understanding Access has a 700+ capacity. More likely then not this is due to a large number of controls I have deleted that still have slots reserved for them in the background. Needless to say i get the "Cannot add more records" error and then my access crashed upon adding another control.

I did a little research and learned that copying a form with a new name, deleting the original, and renaming the new one should clear the history of these deleted controls. My problem is that when I copy and paste this form nothing happens. I can copy it and when I hit paste it asks for a name. I type a name, and then hit ok and nothing happens. The form isnt added to the list. I tried to paste it into a different database and got the same thing. I also tried copying and pasting another form and it worked fine. What would cause this problem?

On a side note, I also tried the compact and repair utility with no result.

[RuralGuy]

Try importing your db into a fresh, new db and see if the problem follows.

[MWB]

When I do this all of the forms except that one will be imported

[RuralGuy]

That means *that* form is corrupt. You may be able to use the undocumented SaveAsText feature to get most of it.

Application.SaveAsText ObjectType AS acObjectType, ObjectName As String, FileName As String

LoadFromText is identical in its parameters. For example:

Application.SaveAsText acForm,"frmMyForm","H:\ClientX\frmMyForm.txt"

Put this in a standard module and run it from the immediate window.