trouble with Visual Basic editor in Access 2007

[dbDeveloperCAdeptCorp]

I have the trial version of Access 2007. When I try entering and editing
code in, for example, an event procedure on a form, the editor does not
maintain the context sensitive help like it did in earlier versions of
Access. It changes what I type before I even finish typing it. The command
or function options expected only show up for a very short time, less than a
second. For example, I can type "msgbox Prompt" and the editor removes the
space between words before I can type the rest of the prompt. The text color
changes to red. Or the list of options after a comma (eg. for type of
message box) disappears before I can pick from it. If I want
"vbOKonly+vbInformation" I have to type it the hard way instead... This does
not happen every time, but I have seen it happen on two different computers
already and it is very irritating. It is not supposed to check for syntax
errors until after a line is finished, but it seems to do it now before the
syntax is complete, so of course it finds errors!... Has anyone else
encountered this? What causes it and how can it be fixed?

 

[Allen Browne]

What you describe is not normal behavior for Access 2007, so something else
must be going on.

Is there any chance something else is running? For example, do you have a
form open that has something in its Timer event?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"dbDeveloperCAdeptCorp" <[email protected]>
wrote in message
news:[email protected]...

 

[dbDeveloperCAdeptCorp]

No; nothing else is running except the VBA editor for one event for one
control on one form. Besides, the timer events are only supposed to run when
the form is open in form view, not in design view. At first I suspected
maybe I had inadvertently left something pressing on the keyboard or mouse,
but on two different computers at different times in different locations?
There is probably some obscure option that is incorrectly set, but I can't
tell what or where...

 

[Allen Browne]

I can assure you that this is not normal. If you are seeing it on 2
computers, there might be a clue in what's common between them. Same video
driver? mouse driver? add-ins? Other software? Ease of Use setting (e.g.
sticky keys)? Key logger?

It is behaving as if something else is interfering with the process, before
you can complete the line of text. Some language settings could affect this,
e.g. a combination of letters followed by a space might be interpreted as a
foreign oraccented character.

Not sure what else to suggest. Perhaps you could create a new user on your
computer, and configure this profile really minimalistically, using US
English as the language, removing any add-ins, and using msconfig to disable
much of the startup software. (The suggestion of new user is so you don't
mess up your main user's profile too much.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"dbDeveloperCAdeptCorp" <[email protected]>
wrote in message