ACC: IPF Referencing ControlSource Containing Code

• Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you switch a form from Form view to Design view, you receive an invalid page fault.

CAUSE

This behavior occurs when the ControlSource property of a control on the form contains a function that tries to change the value of that control.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.

MORE INFORMATION

Steps to Reproduce Problem

1. Open a new blank database in Microsoft Access 7.0 or 97.



2. Create a new module and type the following procedure:
   

   
         Function MyFunction()
   
            Forms(0).Controls(0).ControlSource = ""
   
         End Function 




3. Create a new form in Design View.



4. Add a text box to the form and type the following in the ControlSource property of the text box:
   
   =MyFunction()



5. On the View menu, click Form View (or Form in Microsoft Access 7.0).



6. On the View menu, click Design View (or Form Design in Microsoft Access 7.0).
   
   Note that Microsoft Access returns an Invalid Page Fault.

Additional query words: access violation

Keywords : kberrmsg FmsProb
Version : 7.0 97
Platform : WINDOWS
Issue type : kbbug