Microsoft Access - Put A Stop To Annoying Error Message Boxes By Disabling Syntax Checking During Development (2000/2002/2003)

The fact that the Visual Basic Editor checks your work before you leave a line of code is a really nice feature. However, the message box that pops up identifying an error it encountered can be quite annoying. This is especially true if the error is an obvious typo or you're leaving the line of code unfinished for a reason. Of course, you can easily disable this feature:

  1. Select Tools | Options from the VBE main menu
  2. Then, locate the Auto Syntax Check check box on the Editor tab, clear it, and click the OK button

With this feature disabled, the VBE will still highlight an erroneous line of code when you leave it. However, it won't display a message box identifying the error or return your insertion point to the bad line for correction.

Go back