Microsoft KB Archive/95324

{|
 * width="100%"|

PRB: Current Record Not Immediately Updated with Replace All
'Article ID: Q95324

Creation Date: 07-FEB-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you click the Replace All button in the Replace In Field dialog box, and the focus is on a particular field in a record, that record is not changed until all other records are replaced.

STATUS

This behavior is by design.

MORE INFORMATION

The record that has the focus is refreshed only after all other records in the result set have been updated.

Steps to Reproduce Behavior

 Open the sample database NWIND.MDB.  Create the following query based on the Orders table: Query: QueryTest -     Field Name: Ship City Criteria: =&quot;Seattle&quot;  Run the query. Place the pointer in the first row, between the &quot;e&quot; and &quot;a&quot; in &quot;Seattle.&quot; From the Edit menu, choose Replace. Type &quot;LE&quot; (without the quotation marks) in the Find What box. Type &quot;LEFOO&quot; (without the quotation marks) in the Replace With box. Click to select the &quot;Search Only Current Field&quot; box and click to clear the Match Case and Match Whole Field check boxes. Click Replace All. Note that the first field does not immediately display the change, but does as soon as all other records are updated.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10 2.00

KBCategory: kbusage

KBSubcategory: GnlFnd