Form errormessage is killing me

[Alexandersels]

Can any-one please tell me what I did wrong when I get the next error messages after puting an object into a form.I'm currently runnuing the MS Access 2002 version.

1st message: 'The Microsoft Jet Database Engine does not recognize 'Label 2048' as a valid name of expression'

Followed by thus message: 'Microsoft Assess can't create any more controls on this form or report. If you have deleted controls from this form or report in the past, you may be able to tename the form of report and then add more controls to it'

I found the folowing Acceess 2000 code on the internet.

application.saveastext acForm, "formname", "O:\filename"
application.loadfromtext acForm, "formname", "O:\filename"

But this didn't solve the problem.

Is there a way to solve this problem. Or is my form, as I suspect, really at it's limit for number of objects.

thanks.

 

[Mile-O]

The limit for objects is something in the region of 750 per form. Do you have that many?

Also, if you don't you may need to compact to tell tell access to begin numbering by the lower numbers again.

 

[Alexandersels]

The limit for objects is something in the region of 750 per form. Do you have that many?

Thanks for your reaction.

If labels are included in that number, then I would guess that my form has between 250 and 300 objects. I do have a tabcontrol in the form, I don't know if that makes a difference.

 

[maxmangion]

As SJ_Mcabney suggested, try to compact and repair your database ... it might solve your problem.