Strange and erratic behaviour... 2

[MkIIISupra]

I have tried everything I can think of and still my Access application is acting "strange".
System:
Dell 1.8GHz 512MB PC-2100 RAM, Win2K, Office 2K

What's happening is now when I go to code in the back of a form I am seeing and experiencing a series of issues. I have already turned Auto Complete off to no avail. What is happening is things like:

1. As I start to type a simple If statement the system starts to show red as though there is a syntax error, I press the space bar to place a space between the If and my opening parenthesis like so

If (

and the cursor will jump back to the If. When I finally get the first segment written and I try to finish the line it does the same thing but this time worse!

If (Me.stateDistNum.Value) = "

right there! it will create a closing " and then the cursor will jump in front of the = or if I start to type then the cursor will jump in front of the h in then and finish the text there like so:

tenh instead of Then.

This is only the tip of the iceburg. Now after I finally get the code written everything works fine. But writing the code is a painfully slow process and I have finally just started to use notepad to write my code then copy and paste it into my application.

So does anybody have even and inkling of what I am experiencing? All I know is it's really friggen frustrating!~!!

One by one the penguins steal my sanity!

 

[wtmckown]

Do you have any timer events firing in the application? Perhaps a hidden form with a timer event that fires occasionally? This can cause the problems that you describe. Just stop this code from executing while you are coding if this is the case.

 

[MkIIISupra]

I will check, but I think the only form that has a timer event... wait I do! a clock is running on one of my forms! I will check that hypothosis out. Thanks!

One by one the penguins steal my sanity!

 

[RickSpr]

wtmckown, that was a brilliant intuition! I would never have thought of something else stealing the focus and causing this problem. A * for you!

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[chinitzj]

I came across this thread during one of my random browsings and I'm so glad I read it. I have been having this problem, too and it has been so irritating. Auto Complete is so nice and you don't realize how useful it is until it doesn't work. I had an inactive shutdown form with a timer event and when I closed it my erratic behavior was also corrected. Thanks wtmckown. I also give you a star!