How do you make code autocomplete?

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

When I am typing code in the code window, sometimes I get a drop-down list
of available options, e.g. after I type DoCmd. I get a list of possibilities
like Close, SetWarnings, etc. I then stop using the keyboard, select the
item with the mouse, but when I select it I am dropped to another line in
code. I was watching a short recorded demo yesterday and while that person
wrote code, when he started to type the first letters of the word he needed
(e.g. DoCmd.GoToR) he did something that made the rest of the word fill in
and his curser was in the correct postion to keep typing.

What keyboard method did he use? I tried function keys, enter and return,
the arrow keys, etc.
 
When the correct Method / Property is highlighted, simply hit the space bar
(or another valid separator character as required) and Access will
automatically complete the word for the Method / Property and the separator
character for you.

In fact, it may be faster not to use the mouse. You can just type just
enough characters for the Method / Property you want until the correct one
is highlighted, then type the separator character (space, comma, Enter key,
.... as the required). Enter key will, of course, move the cursor to the
next line.

If you want to select the Property / Method and place the cursor right after
(without the separator character, use Ctrl + Enter.
 
I wish I'd known this years ago!

Thanks!

Van T. Dinh said:
When the correct Method / Property is highlighted, simply hit the space
bar
(or another valid separator character as required) and Access will
automatically complete the word for the Method / Property and the
separator
character for you.

In fact, it may be faster not to use the mouse. You can just type just
enough characters for the Method / Property you want until the correct one
is highlighted, then type the separator character (space, comma, Enter
key,
... as the required). Enter key will, of course, move the cursor to the
next line.

If you want to select the Property / Method and place the cursor right
after
(without the separator character, use Ctrl + Enter.
Click to expand...
 
Back
Top