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
Post a Comment