5 Ways to Fix Microsoft Access Error Code 94: Invalid Use of Null

Getting the “Run-time error ‘94’: Invalid use of Null” in the meanwhile handling your MS Access database can be really distressing. But don’t worry, as in this blog I am going to discuss all about Microsoft Access error code 94 and solutions to get rid of it effortlessly.

So, without any further ado, let’s get started…

Fix Microsoft Access Issues
Run a database Scan with Stellar Access Database Repair Tool to repair inconsistent Access database. After the scan is complete, the repair process will restore the database to its normal state fixing all the errors.

By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Table of Content:

What Does Run-Time Error ‘94’: Invalid Use of Null Mean?

How to Fix Microsoft Access Error Code 94: Invalid Use of Null?

What Does Run-Time Error ‘94’: Invalid Use of Null Mean?

When the runtime error 94 Access occurs then it simply means there’s a blank field in the Access database or it’s in an incorrect format.

Error Detail:

Error NameInvalid use of Null

DescriptionMicrosoft Visual Basic- Run-time error ‘94’: Invalid use of Null.

Error CodeRun-time Error 94

Screenshot Of the Error:

Microsoft Access Error Code 94

This error can be mainly triggered due to conflict programs or corruption in Access database. Apart from that, partial installation or corrupt download of the MS Access software can cause this issue.

However, this Access runtime error can be easily fixed by applying a few tricks mentioned in the next section.

How to Fix Microsoft Access Error Code 94: Invalid Use of Null?

Follow the below step-by-step methods to troubleshoot runtime error 94:

Fix 1- Close the Conflicting Programs

In most of the cases, it has been seen that run-time errors in Access occur due to programs conflicting with each other.

So, if you are suspicion that the runtime error 94 has occurred because of conflicting programs, simply stop them.

For this, follow the below steps:

  • On your Windows desktop, click Ctrl + Alt + Del keys >> click on Task Manager.
  • Now, you will get the list of programs that are currently running in the background.
  • After this, go to a Processes tab & stop each program and then click the End Process button.

Microsoft Access Error Code 94

  • After completing these steps, you have to check for the error. If the issue still persists then follow the next solutions.

Fix 2- Run VBA Code Using NZ Function to Fix Microsoft Access Error Code 94

Since you are experiencing the “invalid use of null” error message in Access so, it is recommended to run VBA using the NZ function. The NZ is a very useful function for trapping the errors triggered by NULL or missing values.

All you need to do is to consider running this streamlined VBA code by using the NZ function:

Dim U As String

U = NZ(Me.txtUnlock,0)

Dim fail as Boolean

If Not IsNumeric(U) Then

    MsgBox “Unlock pin only accepts numbers only.”, , “Retail unlock”

    fail = true

ElseIf Len(U) <> 4 Then

    MsgBox “Retail unlock must be four digits long.”, , “Retail unlock”

    fail = true

End If

If fail then

    With Me.txtUnlock

        .value = vbNullString


    End With

End If

And you are done!

This will eventually help you to solve your problem.

Fix 3- Repair Database Using Compact and Repair Utility

As already mentioned above, corruption in the Access database is the foremost reason for the occurrence of the run time error 94 invalid use of null Access.

In such a case, running MS Access Compact & Repair tool can come handy. But before using this Access built-in tool, it is essential to remember the following things:

How to Compact and Repair Database:

  • Open Microsoft Access program.
  • Next, double-tap on a Blank desktop database.
  • Go to the File >> click on Close.

Microsoft Access Error Code 94

  • Now, on the Blank Database >> go to a File
  • In the Database Tools, you have to click on “Compact and Repair Database”.

Microsoft Access Error Code 94

  • Then, choose the Access database throwing a runtime error 94 & which you wish to compact & repair. Click Compact.

Finally, you will get a copy of repaired database saved in the location where your actual file is stored.

Fix 4: Execute Windows Clean Installation

Microsoft Access Error Code 94

Many users have reported that they fixed run time error 94 invalid use of null Access by reinstalling the Windows operating system. therefore, you should also try to reinstall Windows OS.

This will erase everything from your hard drive and allow your system to start fresh.

Fix 5: Repair Corrupt/Damaged MS Access Database

Even after following the above methods, if the error still persists, you should opt for MS Access Repair and Recovery Tool. This program will eventually help you to repair the corrupt Access database and solve run time error 94 successfully.

Although it has the ability to fix corruption in .mdb or .acccdb files & recovers data from the corrupted Access database.

Not only this, it also restores the indexes, relations, tables, queries, and other stuff in a few simple clicks.

Key Features of Access Repair & Recovery:

  • Easily retrieve deleted linked tables, forms, tables, modules, indexes, reports, relations, queries, records, macros, etc.
  • Restores password-protected Access DB or encrypted database.
  • Supports all the OS VERSIONS like 11, 10, 8.1, 8, 7, Vista, & XP.
  • Compatible with Access 2010, 2013, 2016, 2019& later versions.
  • User-friendly
  • 100% trusted & easy to use.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

So, just download & install this program on your PC & follow the below steps to learn how it works:

Time to Conclude:

Well, I have stated all the possible solutions to fix Microsoft Access error code 94: invalid use of null.

So, try them one by one until your issue gets resolved. And even do share your experiences with us.

Apart from that, if anyone of you’ve more solutions to troubleshoot this specific error code, you can comment on our Facebook or Twitter accounts.

Good Luck…!

tip Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

  1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.