Moving cursor while programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

It looks like my code is being checked with each word, so when I type for
example "Dim" then space over ready to type my next text, "Dim" turns red, as
in an error and repositions my cursor back up against the "Dim".

Example of what I want "Dim vSQL" and this is what I get "DimvSQL"

Has anyone seen this and is there a way to turn this off? I'm running
access 97.
 
Mark,

Any chance there is an open form with a timer event when this is happening?

HTH,
Nikos
 
MArk,

Your options include:

* Closing the form while in the VBA window
* Reverting to design view while in the VBA window, so the timer event
doesn't fire
* Programatically disabling the timer event while in the VBA window, by
running:

Forms![Form Name].TimerInterval = 0

in the immediate window; when done, close the form without saving so
this setting isn't saved, or restore to the previous setting in the same
fasion and save.
Dring development, you might find it useful to store two small subs in a
module to set / reset without typing each time:

Sub Suspend_Timer()
Forms![Form Name].TimerInterval = 0
End Sub

Sub Restore_Timer()
Forms![Form Name].TimerInterval = 1000 '(or whatever)
End Sub

HTH,
Nikos
 
Back
Top