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

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:The previous message is then followed by the following message: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.

Notes

• 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 Method Syntax

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.