Microsoft KB Archive/209582

= ACC2000: Can't Find Macro Error Message =

Article ID: 209582

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209582



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



SYMPTOMS
When you are entering data in a form, you may receive the following error message:

Microsoft Access can't find the macro '.'



CAUSE
This behavior can occur if you inadvertently type one or more spaces in the event properties of either a form or a control, such as in the OnCurrent or the AfterUpdate property.



RESOLUTION
Open the form in Design view and remove the space(s).



MORE INFORMATION
You should be able to determine whether the space is located in a control's event property or a form's event property, based on what actions trigger the message.

For example, if the error occurs in one of the following situations, check the suggested properties.


 * Opening the form:
 * Check the Form's OnOpen, OnCurrent, or OnLoad property.
 * Check the OnEnter property for the first control that receives the focus when the form is opened.
 * Check the OnGotFocus property of controls in Microsoft Access.
 * Typing in a control:
 * Check the control's BeforeUpdate and AfterUpdate properties.
 * Check the control's OnKeyDown, OnKeyPress, OnKeyUp, and OnChange properties.
 * Saving a record:
 * Check the form's BeforeUpdate and AfterUpdate properties.
 * Moving to a new record:
 * Check the form's OnCurrent property.

Note: This is not a complete list of causes.

After you have determined which property is causing the behavior, open the form in Design view and remove the space from that property. If you are still not sure which property is causing the behavior, go to each property that is blank and press the DELETE key.

NOTE: You may have spaces in multiple properties; therefore, it is a good idea to check them all.

Steps to Reproduce Behavior
This example uses the sample database Northwind.mdb.


 * 1) Open the Employees form in Design view.
 * 2) Display the property sheet by clicking Properties on the View menu.
 * 3) Select the Last Name control and type a single space in the AfterUpdate property.
 * 4) View the form in Form view, and type data in the Last Name control. Note that when you try to exit this control, you receive the error message mentioned in the SYMPTOMS section of this article.

