Others

How to Fix Microsoft Access Error 3085 for an Undefined Function

Huma Ashraf ChHuma Ashraf Ch Oct 22, 2026 868 views

Question details

The user needs to fix Error 3085 (Undefined Function) when trying to run an expression that converts and divides a field value while removing its final character.

How to Fix Microsoft Access Error 3085 for an Undefined Function
Product
Microsoft Access
Device & OS
not provided
Scenario
Writing or executing a field expression in a database query to manipulate and calculate string or numeric values.
Observed behavior
The database returns Error 3085, indicating an undefined function, which prevents the query from executing properly.
Before you start

Verify the exact data type (numeric or text) of the target field in your table's Design View, and check your system's regional settings to see if your list separator defaults to a comma or a semicolon.

Solution 1Recommended

Simplify Expression Syntax and Adjust Separators

Adjusting your formula to properly match the field's data type and correcting your regional list separators will resolve most Error 3085 issues.

Error 3085 is often triggered when an expression uses incorrect syntax for the data type, or when the regional settings of your operating system expect a different character to separate function arguments.

1
Use Integer Division for Numeric Fields

If the target field (e.g., CELLID) is a numeric data type, bypass complex text manipulation by using the backslash operator for integer division. Enter the expression: RBS_ID: [OMC_UMTS_OBJECTS_INFO].[CELLID]\10

2
Apply Right Function for Text Fields

If the field is text-based, use the Right function to strip the last character before dividing. Enter the expression: RBS_ID: ([OMC_UMTS_OBJECTS_INFO].[CELLID]-Right([OMC_UMTS_OBJECTS_INFO].[CELLID],1))/10

3
Adjust Regional Syntax Separators

If you still receive a syntax error, your Windows regional settings may require semicolons instead of commas. Change the comma in your function to a semicolon, for example: Right([OMC_UMTS_OBJECTS_INFO].[CELLID];1)

Simplify Expression Syntax and Adjust Separators
Regional Settings Impact: In many European regions, the semicolon (;) is the default list separator in Microsoft Access formulas instead of the standard comma (,).
Free Microsoft Office alternative

Manage Data Easily with a Free Microsoft Office Alternative

While Microsoft Access is built for relational databases, much of your daily data sorting, formula calculations, and data analysis can be handled easily in a robust spreadsheet program. WPS Office provides a free, lightweight suite that serves as a seamless alternative for Microsoft Office users.

  1. 1. Download WPS Office: Visit the official WPS Office website and click the Free Download button.
  2. 2. Install the Suite: Run the downloaded installer and follow the on-screen prompts to set up the software.
  3. 3. Manage Your Data: Open WPS Spreadsheet to import your CSV or Excel data files as an intuitive alternative to complex database management.
Seamlessly handle data processing and troubleshoot complex formulas with advanced Spreadsheet capabilities.Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight design ensures fast loading and smooth performance on all devices.Familiar tabbed interface allows you to start working immediately without a learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

What does Error 3085 mean in Microsoft Access?

Error 3085 indicates that Access encountered an 'Undefined Function' in an expression. This usually happens if you mistype a function name, use a function not supported in the current context, or use incorrect parameter separators.

Why is the Right() function causing an undefined function error?

The Right() function can trigger this error if there is a missing or corrupted reference in your database's VBA project, or if your system's regional settings require a semicolon (;) instead of a comma (,) to separate the function arguments.

Can I use integer division instead of string manipulation in Access?

Yes, if your field's data type is set to Number, you can use the backslash operator (\) for integer division (e.g., [Field]\10). This automatically truncates the decimal portion, removing the need for text functions like Right() or Left().