Microsoft KB Archive/275063

= ACC2002: Name AutoCorrect Does Not Repair Certain Form or Report Property Settings =

Article ID: 275063

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q275063



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
After you rename fields within a table, you open a form or report that is based on that table and you are prompted to enter parameter values. When you check the design of your form, you find that all the controls on the form have been properly fixed by Name AutoCorrect.



CAUSE
Name AutoCorrect does not automatically fix the values in certain form properties, such as the Filter and OrderBy properties.



RESOLUTION
You must manually set these properties to the new values.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The AutoCorrect feature in Microsoft Access 2002 does not fix or repair certain property settings in an Access form or report. For example, the Filter property of a form contains the name of a field in a table. If you then change the name of that field in the table, the AutoCorrect feature does not automatically change the field name in the Filter property of the form.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce the Behavior
 Open the Northwind sample database. On the Tools menu, click Options. In the Options dialog box, click the General tab. Make sure that the Perform name AutoCorrect check box is selected, and then click OK. On the View menu, point to Database Objects, and then click Forms. Open the Orders form in Design view.</li> In the property sheet for the form, click the All tab.</li> Set the Filter property as follows:

[CustomerID] = 'BERGS'

</li> Scroll down to the OnLoad property, and then click the Build (...) button. In the Choose Builder dialog box, click Code Builder, and then click OK.</li>  Type or paste the following code: Private Sub Form_Load Me.FilterOn = True End Sub </li> On the File menu, click Close and Return to Microsoft Access.</li> On the View menu, click Form View. Note that the form is filtered to display only records for Berglunds snabbkop.</li> Close the form, and when you are prompted to save changes, click Yes.</li> Open the Orders table in Design view, and then change the CustomerID field name to Customer ID by inserting a space between Customer and ID.</li> Close the table and when you are prompted to save changes, click Yes.</li> Open the Orders form in Form view. Note that you are prompted with an &quot;Enter Parameter Value&quot; prompt for CustomerID.</li></ol>

Additional query words: pra get receive are asked for dialog box

Keywords: kbbug kbnofix KB275063

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.