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 - 31 May 2006 18:51 GMT
> 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

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
aevargareg - 01 Jun 2006 16:50 GMT
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 - 19 lines]
> [x] Auto Quick Info
> [x] Auto Data Tips