Auto Suggest in Macro (VB) editor ("str"->"STRING")

[andysuth]

Hi,

I've lost a setting in Access, and I can't find it, can someone please tell me how to turn on "Auto Suggest".

Last project I was programming I'd type somthing like:

"me.hel"

and it would automatically suggest something that was a part of the form like a text box called "hellomacro"

so by typing:
"me.hel" <space>

you could get

"Me.HelloMacro" as a suggestion.

Similarly:

"dim var1 as St"

would volunteer:

"Dim var1 as String"

I don't know what this feature is called or where it is, can someone suggest how I can turn it on?

Thanks.

-Andy

[OBP]

Andy, in the VBA Editor Main Menu>Tools>Options>Auto List members.

[CreganTur]

A little FYI: typing certain things can turn off intellisense as well; for the current line, not for the whole IDE. For example: if you use a bang(!) instead of a dot (.) when working with objects and methods intellisense will not work... which is why we suggest using the dot.

[Oorang]

Another gotcha is non-compiling code. If you cannot compile (debug>compile) the intellisense will not work until the syntax errors have been resolved.