Microsoft KB Archive/248928

From BetaArchive Wiki
Knowledge Base

ACC2000: Incorrect OnCurrent Field Property in Macro That Is Converted from Access 2.0

Article ID: 248928

Article Last Modified on 11/25/2002


  • Microsoft Access 2000 Standard Edition

This article was previously published under Q248928

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

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


After you convert a database from Access 2.0, you find that a macro containing the FindRecord action is not behaving as expected.


No matter what you set for the Search In property of the FindRecord action in Access 2.0, the setting is translated incorrectly in Access 2000. If you had Search In set to Current Field in Access 2.0, the corresponding Only Current Field property in Access 2000 is set to No instead of Yes. If you had Search In set to All Fields in Access 2.0, the corresponding Only Current Field property in Access 2000 is blank, instead of being set to the expected No.


To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this problem, open the macro in Design view in Access 2000, and then set the Only Current Field property of the FindRecord macro to the desired setting of either Yes or No.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.


The FindRecord action has changed slightly since Access 2.0. In Access 2.0, the Search In property has two settings: All Fields or Current Field. In Access 2000, this option is translated to the property called Only Current Field, which has a Yes or a No setting. This property serves the same purpose; however. Yes indicates that only the current field is searched and is equivalent to setting Current Field for the Search In property in Access 2.0. No indicates that all fields are searched, and is equivalent in Access 2.0 to setting All Fields for the Search In property.

Additional query words: pra 2 0

Keywords: kbbug kbfix KB248928