autocorrect/syntax check

[Don Ireland]

I am not sure why this is happening....

I am in the visual basic editor trying to update the code for a database.
As I type, the code backs up, turns red and otherwise annoys me as I am
trying to type. I have turned off the Auto Syntax Check as well as all of
the "auto" do anything features under the Tools - Options Editor Tab.

It is really annoying as it completes goofs up the code as I type. How do I
shut this off? The odd thing is that it didn't use to do that. It started,
then stopped, and has started again.....

Does anyone have any ideas??????

Thanks in advance

Don

 

[Allen Browne]

Don, any chance you have a form with a Timer event?

 

[Don Ireland]

No timer event.... It also completely ignores spaces... automatically
inserts double-quotes when a syntax requires them, and a few other oddball
things.

Please keep in mind that this happens when programming in VB not when using
the actual database. Alse, the behavior is not evident when programming
Excel VB...only Access.

 

[Allen Browne]

Don't know what to suggest, Don, so if anyone else has an idea, please jump
in.

Presumably you have disabled any other Add-ins in the VBA window?
Never had the VBA IDE sticking quotes in for me.
Had a worn-out keyboard where Spacebar did not work reliably.
AutoKeys marco should not affect VBA window.
Keyloggers/viruses/generic keyboard enhancers could be a factor.

 

[John Spencer]

To reiterate what Allen Browne said.

The only time I've seen this behavior is when I have a form open with a timer
event running. It doesn't have to be the form I am working on, any form (even a
hidden one) with a timer grabs the focus when the timer event gets triggered.

 

[Duane Hookom]

I third that "reiterate" or would it be a second of the "reiterate"....
These are the exact symptoms of any other form currently open and running
code in the timer event.

 

[Don Ireland]

I FOUND THE PROBLEM!!!!!!!!!!!!!!!!!

It was exactly what everyone said and then reiterated multiple times. There
was a subroutine that was started for the timer event. All of the code was
removed except for the Sub <form name> timer and End Sub statements. The
timer value was set to 1000 so it was checking the timer every second. I
think at one point, we tried putting a clock in the database but that caused
problems for some and annoyed others, so it was removed - partially.

Thanks for all the help! It only took about a month to find!