Search code examples
vbams-accesssyntaxms-access-2013

Access VBA: How do I make the VBA editor stop auto-filling values?


I already turned off auto-syntax check but this problem still persists. Whenever I try to modify a time, let's say from 08:30:00 AM to 08:30:05 AM, Access sometimes fills in a zero after I backspace to clear the 0. It forces me to have to quickly change the value otherwise it gives me an annoying pop up message saying syntax error....but the editor caused the error, not me!

How do I fix this? Please help me fix this.


Solution

  • This happens when code is running, which forces Access to constantly compile the VBA source code.

    Typical example: a form is open that uses the OnTimer Event (has TimerInterval > 0).

    To prevent this: Close all forms while editing code (Design view is ok).

    If it's not forms, press the "Stop" button in the VBA toolbar (the blue square) to stop all running code.