Display a list of relevant objects, properties, and methods in the Visual Basic Editor Code window

Display a list of relevant objects, properties, and methods in the Visual Basic Editor Code window

  1. On the Tools menu, click Options.

  2. Click the Editor tab.

  3. Under Code Settings, make sure Auto List Members is selected.

When Auto List Members is selected, Microsoft Access assists you in completing statements while you're writing Visual Basic code. When you type the name of an object, followed by a space or opening parenthesis, Microsoft Access displays a list of relevant objects, properties, and methods that could follow the object name. There are several keys you can use to enter an item from the list into the current line of code.

Key Effect
TAB Enters the item
SPACEBAR Enters the item followed by a space
ENTER Enters the item and moves the cursor to the next line

Note   To make the list disappear, press ESC.