IDE autocomplete

[aevargareg via AccessMonster.com]

I am tasked with maintaining another author's database, and I can't figure
out how he turned off the autocomplete feature in the IDE, for example:

1) Start a line with "Me." and see a list of objects appear for the current
form or report.
2) Type a couple of letters, press the tab key and the object's full name is
added to the statement.
3) Type another trailing period and a list of the object's methods and
properties appears.
4) Type a couple of letters, press the tab key and the property is added the
statement.

Without autocomplete I can't be sure I'm even typing the name correctly,
although the IDE assumes I know what I'm doing and adds reasonable
capitalization. Where can I enable this? All of the databases I have
authored already work this way, but this database had restrictions imposed to
prevent inadvertent user tampering (there are hidden windows and forms don't
always have size controls).

Thanks, Alan

 

[Rick Brandt]

I am tasked with maintaining another author's database, and I can't
figure out how he turned off the autocomplete feature in the IDE, for
example:

1) Start a line with "Me." and see a list of objects appear for the
current form or report.
2) Type a couple of letters, press the tab key and the object's full
name is added to the statement.
3) Type another trailing period and a list of the object's methods and
properties appears.
4) Type a couple of letters, press the tab key and the property is
added the statement.

Without autocomplete I can't be sure I'm even typing the name
correctly, although the IDE assumes I know what I'm doing and adds
reasonable capitalization. Where can I enable this? All of the
databases I have authored already work this way, but this database
had restrictions imposed to prevent inadvertent user tampering (there
are hidden windows and forms don't always have size controls).

Thanks, Alan

Access 97

Tools
Options
Modules
[x] Auto List Members
[x] Auto Quick Info
[x] Auto Data Tips


Access 2000 - 2003 (in VBE Editor)\

Tools
Options
Editor
[x] Auto List Members
[x] Auto Quick Info
[x] Auto Data Tips

 

[aevargareg via AccessMonster.com]

Thanks Rick, that did it.

Alan Varga

I am tasked with maintaining another author's database, and I can't
figure out how he turned off the autocomplete feature in the IDE, for

[quoted text clipped - 17 lines]

Thanks, Alan

Access 97

Tools
Options
Modules
[x] Auto List Members
[x] Auto Quick Info
[x] Auto Data Tips

Access 2000 - 2003 (in VBE Editor)\

Tools
Options
Editor
[x] Auto List Members
[x] Auto Quick Info
[x] Auto Data Tips