ACC2000: Error Message: The Expression May Not Result in the Name... (224344)

ERROR MESSAGE

When you run a procedure, you may receive the following error message:

The expression <expression> you entered as the event property setting produced the following error:

The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].

There may have been an error evaluating the function, event, or macro.

NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C

NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.

THINGS TO TRY

A user-defined function or a subroutine has the same name as a module

This type of error can occur even if the procedure is not contained in the module with the same name. To avoid this type of error, change the name of the procedure or function so that it is different from the name of any module that you have in the database or project.

An event for an ActiveX control uses OLE_COLOR for a parameter

When handling an event for an ActiveX control in a form, you may see this error if any of the events use OLE_COLOR for a parameter.

If you have the source code for the control, change the parameter that is using OLE_COLOR to a different type, such as Long. Otherwise, you cannot catch the event of the control.