ACC: IPF Referencing ControlSource Containing Code

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

The ControlSource property of a text box on a form causes Microsoft Access to return an Invalid Page Fault when switching from Form view to Design view.

This behavior occurs when the ControlSource property contains a function that changes the value of the control.

CAUSE

An attempt is made to change the ControlSource property of the control while it is being evaluated.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

WARNING: Following these steps will cause a general protection fault on your computer. Make sure you save and close any open work on your computer before following these steps.

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.