How to Fix Microsoft Access Error 3085 for an Undefined Function
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.

- 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.
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.
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.
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
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
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)

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. Download WPS Office: Visit the official WPS Office website and click the Free Download button.
- 2. Install the Suite: Run the downloaded installer and follow the on-screen prompts to set up the software.
- 3. Manage Your Data: Open WPS Spreadsheet to import your CSV or Excel data files as an intuitive alternative to complex database management.

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().




