VBA Code Autofill Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When entering VBA form code, Access auto-formats the code and prompts you for
required info based on what is typed (ex: when 'Msgbox(" is typed, Access
provides prompts for the subject, Title, and dropdown lists of acceptable
options, etc as you type.).

Sometimes when I type code, this autofill feature does not function
correctly and results in bad code. For example, when I type "Dim(spacebar)"
to enter a Dim statement, Access backspaces to the 'm' instead of adding the
space I wanted, so if I type 'Dim x as s', the result will actually be
'Dimxass', and Access will not dropdown the list of options to preselect
'String'.

I can't figure out why it does this. Any help or advice on this problem? I'm
using Access 2003 and XP Prof. I've tried stopping the debugger but the
problem continues.
-Larry
 
Maybe you have a form open with a Timer event? When that event fires,
code is run, and the line you're editing is automatically syntax checked
and precompiled.

Larry said:
For example, when I type "Dim(spacebar)"
to enter a Dim statement, Access backspaces to the 'm' instead of adding the
space I wanted, so if I type 'Dim x as s', the result will actually be
'Dimxass'
Click to expand...

I'd rather not have Access use such language to me ;-)
 
Back
Top