Why is my VBA for MS Access Buggy? -


this kind of vague question , hard explain. i'm trying code access database, vba portion annoying me. whenever type , hit space, automatically redo space , put me against previous word typing. also, intellisense come split second, flicker , go away, , revert cursor text typing. results in me typing things in places shouldn't , lack of spaces between elements of code. know why occuring? database i'm using created in access 2007, developing in 2010. @ top says microsoft access 2007-2010.

thanks help.

the cause have form open active timer event.

what happening editing code, there code running @ regular interval. each time other code runs, just-in-time compiler vba runs.

normally when writing code, real-time compilation happens whenever move 1 line of code another: compile errors raised, trailing white space trimmed, etc.

however, in case have piece of code running. before can run, compiler must run. , same things does. annoyingly, trims trailing white space line.


the solution close form active timer event, or set timer interval 0 while editing code.


Comments

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -