Can't turn error correction

  • Thread starter Thread starter Mark Riaboy
  • Start date Start date
M

Mark Riaboy

For some reason, when I'm working in VBA with Access 2002 during the past
few days,automatic error correction seems to have turned on and I can't get
it to turn off. It gets frustrating when I try to type a line and VBA
doesn't allow me to insert spaces or type in accepted code before VBA tries
to change it. I thought Auto Syntax Checking was on in
Tools->Options->Editor->Auto Syntax Check, but it's not. I tried to turn
Auto Syntax Check on and off again, but VBA still appears to try to do
automatic error correction. I also tried to remove Option Explicit from the
module, but the problem still exists. To further complicate the situation,
the auto error correction doesn't always turn on. Occasionally, it seems to
have turned itself off, but then can start up again on it's own. Am I
missing something or is there some way to turn off the VBA automatic error
correction in Access 2002?
 
Mark Riaboy said:
For some reason, when I'm working in VBA with Access 2002 during the past
few days,automatic error correction seems to have turned on and I can't get
it to turn off. It gets frustrating when I try to type a line and VBA
doesn't allow me to insert spaces or type in accepted code before VBA tries
to change it. I thought Auto Syntax Checking was on in
Tools->Options->Editor->Auto Syntax Check, but it's not. I tried to turn
Auto Syntax Check on and off again, but VBA still appears to try to do
automatic error correction. I also tried to remove Option Explicit from the
module, but the problem still exists. To further complicate the situation,
the auto error correction doesn't always turn on. Occasionally, it seems to
have turned itself off, but then can start up again on it's own. Am I
missing something or is there some way to turn off the VBA automatic error
correction in Access 2002?
Click to expand...

This is what happens if you try to write code while a form with a Timer
event is open. Every time the Timer event fires you lose focus briefly and
this makes the auto-syntax checker fire off. If you close all your forms
the problem should go away.
 
Back
Top