Others

Fix Microsoft Access Error 3085: Undefined Left Function

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

Resolve Microsoft Access error 3085 when the built-in Left function is reported as undefined.

Fix Microsoft Access Error 3085: Undefined Left Function
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.
Before you start

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.

Solution 1Recommended

Repair missing VBA references in Access

Check references first when Access reports that the built-in Left function is undefined.

1
Open the database without startup code

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.

2
Open the references list

Press Alt+F11 to open the VBA editor, then select Tools > References.

3
Fix missing 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.

4
Compile and retest

In the VBA editor, select Debug > Compile, then return to Access and run the query or action that caused the error.

Repair missing VBA references in Access
VBA editor availability: Access Runtime does not provide the full VBA editor. Open the database in the full version of Access to inspect and repair references.
Free Microsoft Office alternative

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.

Work with spreadsheet data in a familiar interfaceOpen and edit Microsoft Office formats, including XLSX, DOCX, and PPTXUse a free, lightweight office suiteMove compatible documents and spreadsheets without changing your usual file formats
microsoft office alternative - wps office

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.