ACC2000: "Undefined Function '{FunctionName}' in Expression" When You Open a Data Access Page

In a data access page, if you call a function that is not available outside of Microsoft Access, you receive the following message when you open the page in Microsoft Internet Explorer: This message is followed by another message: This error does not occur when you open the data access page in Access.

When you open the page in Internet Explorer, certain Access-specific functions are not available. For example, you see this message if your data access page is based on a query in which an expression contains Nz(), EuroConvert(), Eval(), or a user-defined function.

You also receive this message 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.

However, two of these functions, Nz() and Euroconvert(), have been added as methods of the Microsoft Data Source Control (MSODSC) object. If you want to use Nz() and Euroconvert() in a data access page, you can do so by using the following syntax:

Euroconvert Method
Nz Method

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

For more information about these and other methods of the DataSourceControl object, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type DataSourceControl Methods in the Office Assistant or the Answer Wizard, and then click Search to view the topic.