Access 2003 crashes when I add an option group 1

[OzFoxy]

My .mdb includes a form with 7 option groups on it (3,4, or 5 options), and I need another option group. When I add it to the form, and either save the form or switch to Form View, Access crashes with the 'Microsoft Office Access has encountered a problem and needs to close ....' dialogue box.
Compact and repair has not solved the problem. It compiles OK. The database has been working fine for months, and still does after the crash when it reverts to the saved version.
Is there a limit on the number of Option Groups / Options?
Do I need to increase stack space or something?
I have exhausted all the options I can think of.
Thanks in anticipation

 

[kjv1611]

Just to test and see, is it possible for you to create a new blank database, and copy all the objects into the new database, and THEN add the new option group - in the new database? That's just to see if some odd something has happened to the mdb file that Access isn't picking upon during the compile and repair process.

Another thought - do you have any code that loads with the Form_Load() event? If so, make sure it is updated to match the change in Form design.

 

[MajP]

I agree with the above as my first step as it is always a good thing to do
1) create new blank db
2) import (not copy) all access forms, reports, modules, and tables into the new db
3) try to edit your form

I am pretty sure that you will still see the same problem.
4) Create new blank form
5) Copy objects onto the new form
Should fix it. If the copy does not work
6) Build form from scratch

The problem is that there could be corruption in the form itself or one of the controls. The likely problem is that you exceeded the number of controls for a form (750 I believe). However this number includes all current and all deleted controls over the forms lifetime. If you do a lot of editing of the form, you may only have a limited amount of visible controls but hundreds of deleted controls.

 

[MajP]

Not saying it is a limit issue, but here are the limits FYI

http://blogs.msdn.com/access/archive/2006/06/05/618366.aspx

The number is 754.

 

[kjv1611]

Thanks for the reference, MajP. I'm sure I've seen it before, but I was sure to bookmark it this time.

 

[BlackBeltJoel]

I just experienced the same exact problem and I found out the cause. It had to do with one of the text fields on my form had a FORMAT property of 'FIXED' and and INPUT MASK of '9999'. When I removed these 2 properties the crashes stopped. This field is an alphanumeric text field that should never had those properties assigned to it.

Since I tend to create new forms by copying from similar old ones, this explains why I assigned htese properties to this field...