I thought I had it beaten but I was wrong.
I deleted my clock and the editor worked fine but next time in it was doing
the same thing.
It is fine in design mode and tries to autocorrect in all my forms.
> >I am not intentionally using a timer. Is there any way to search for timers
> > in my code? This problem doesn't happen in my backup copies from a couple of
> > days ago.
>
> It would have to be running in a form that you have open at the same time you
> are in the code editor.
> I thought I had it beaten but I was wrong.
> I deleted my clock and the editor worked fine but next time in it was
> doing
> the same thing.
> It is fine in design mode and tries to autocorrect in all my forms.
This is the classic symptom of having a form open with a Timer event
that is firing, as Doug and Rick pointed out. In the Access application
window (as opposed to the VB Editor window) check every open form -- and
subforms on those forms -- to see if it has an active Timer event. Bear
in mind that forms may be hidden, in which case you may click the menu
item Window -> Unhide... (if that option is disabled, there are no
hidden forms).
I suppose it is possible that your symptoms are caused by something
else, but I have never seen such a case. We've seen these symptoms a
lot, and it has always been due to the firing of a Timer event. Do you
understand what we mean by a Timer event? The relevant properties in a
form's property sheet are the Timer and TimerInterval properties on the
Event tab of the form's property sheet in design view.

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
dhowe - 30 Oct 2004 10:23 GMT
Thanks Dirk.
I deleted my clock but left my timer "event procedure" and my timer interval
in the event properties. Once I deleted these it was fine. If I needed a
clock on my form how would i do it without having the same problem?
> > I thought I had it beaten but I was wrong.
> > I deleted my clock and the editor worked fine but next time in it was
[quoted text clipped - 16 lines]
> form's property sheet are the Timer and TimerInterval properties on the
> Event tab of the form's property sheet in design view.
Dirk Goldgar - 31 Oct 2004 03:37 GMT
> Thanks Dirk.
> I deleted my clock but left my timer "event procedure" and my timer
> interval in the event properties. Once I deleted these it was fine.
> If I needed a clock on my form how would i do it without having the
> same problem?
I don't think you can, without going to extreme lengths -- setting up
some task external to Access that would run the timer. But there's
nothing wrong with having a timer event on a form; it's just that you
don't want to edit code while that form is open in form view and the
timer is running. Is there some reason you need to have this clock form
open while you're editing code?

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)