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

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

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

SYMPTOMS

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

CAUSE

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.

RESOLUTION

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.

STATUS

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.

MORE INFORMATION

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.