You are currently offline, waiting for your internet to reconnect

Error message when you open a data access page in Internet Explorer: "Undefined function '{FunctionName}' in expression"

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

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

For a Microsoft Access 2000 version of this article, see 304755.
For a Microsoft Access 2002 version of this article, see 274379.
When you open a data access page by using Microsoft Internet Explorer, and that data access page contains a function that is not available outside Access, you may receive the following error message:
Data Provider failed executing a provider command.
The previous message is then followed by the following message:
Undefined function '{FunctionName}' in expression.
However, when you open a data access page by using Access, the error messages do not appear.
When you open a data access page by using Internet Explorer, certain Access-specific functions are not available. As a result, you may receive the error messages that are in the "Symptoms" section.

For example, you receive the error messages if a data access page is based on a query that has an expression that contains the Nz() function, the EuroConvert() function, the Eval() function, or a user-defined function.

You may also receive the error messages if you use one of these functions in a control (such as a text box) on a data access page.
  • This is a known limitation of data access pages.
  • You cannot create or modify data access pages in Microsoft Office Access 2007.
You can work around this problem with two of these functions, Nz() and Euroconvert(). Nz() and Euroconvert() may be added as methods of the Microsoft Data Source Control (MSODSC) object. If you want to use the Nz() method or the Euroconvert() method in a data access page, you can use the following syntax:

Euroconvert Method Syntax
Nz MethodSyntax
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
ACC2007 ACC2003 euro convert code won't work dap internet browser eval undefined function functionname in expression

Article ID: 824279 - Last Review: 12/08/2015 03:42:02 - Revision: 2.1

Microsoft Office Access 2007, Microsoft Office Access 2003

  • kbnosurvey kbarchive kbvba kbprogramming kberrmsg kbdapscript kbdap kbquery kbbug KB824279