Fix Microsoft Access Error 3085: Undefined Left Function
Question details
Resolve Microsoft Access error 3085 when the built-in Left function is reported as undefined.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Running a query or database code that uses the VBA Left function.
- Observed behavior
- Access reports run-time error 3085 and says the Left function is undefined, potentially because a VBA reference is missing or broken.
Identify the database that produces the error and make sure you have access to the full version of Microsoft Access, which includes the VBA editor. If an AutoExec macro prevents you from opening the database normally, try holding Shift while opening it.
Repair missing VBA references in Access
Check references first when Access reports that the built-in Left function is undefined.
Hold Shift while opening the database in Access to bypass the AutoExec macro and other startup settings. The bypass may not work if it has been disabled for the database.
Press Alt+F11 to open the VBA editor, then select Tools > References.
Look for entries marked MISSING. Restore the required library or update the reference to an available version; clear a missing reference only if the database does not need it.
In the VBA editor, select Debug > Compile, then return to Access and run the query or action that caused the error.

Test whether the error affects other Access databases
Use a blank database to distinguish a database-specific issue from a broader Office installation issue.
Repair or rebuild the affected Access database
Try these recovery steps if the Left function works in a new database but still fails in the original.
Use WPS Office for familiar document and spreadsheet work
WPS Office is a free, lightweight, easy-to-use alternative for documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support make it easy to move compatible files, but it does not repair Access references or run Access databases.

Frequently Asked Questions
Why does Access say the Left function is undefined?
A missing or broken VBA library reference can prevent Access from resolving built-in functions. Open the VBA editor with Alt+F11 and check Tools > References for entries marked MISSING.
How do I open the database without running AutoExec?
Hold Shift while opening the database in Access. This bypasses the AutoExec macro and other startup settings unless the database has disabled the bypass.
What if Tools > References is unavailable?
Make sure you are using the full version of Access rather than Access Runtime, and open the VBA editor with Alt+F11. If startup code is running, close and reopen the database while holding Shift.
Should I remove every reference marked MISSING?
No. A missing library may be required by the database. Under Tools > References, restore or update a required reference, and clear it only if it is not needed.
Can WPS Office fix an Access VBA reference?
No. Repair Access references in the full version of Microsoft Access. WPS Office can work with compatible Office documents and spreadsheets, but it does not run Access databases.




