Report control limits

[Sam23]

I am using MS Access 2007.


I am designing a complicated report with numerous controls, perhaps over 60 controls. I seem to be hitting a memory limit as it errors and closes the app, tries to backup and restart the app every time I try to add one more control. Is this a known issue with reports?

My CPU is using 4 gigs of RAM.

Thanks so much,
Sam

[ajetrumpet]

not sure. but it IS a known issue that reports and forms do that when they become corrupted. There is a bug in Access of this nature. And it seems to be linked to the amount of "unsaved" changes that happen on the objects. But yeah there could be an issue with the number of controls too, although I doubt it.