Okay, this is bothering me and I thought someone might have a quick fix:

When using VBA in Access 2003, sometimes the auto complete works, and sometimes it doesn't.

Specifically, if I name an ADODB.Recordset "rs", then auto complete will not work for like rs.Open (it won't supply anything after the .) and it won't suggest recordset types or lock types.

If I name the ADODB.Recordset "rsL" auto complete DOES work.

I am not sure if this makes a difference, but I will use multiple ADODB.Recordsets to open a few tables at once and pass data back and forth, so maybe it has to do with which one is opened first? I haven't really noticed a difference other than it doesn't like "rs". Could it be a reserved word?

Thanks,

mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

I do not have a solution to this, but I have noticed the same thing happening to me. When I'm working with objects and controls, this will sometimes happen, but it is seemingly random.

First, I tried your ADO "rs" example, and I have the same problem. This is bizzarre. I had never noticed this before because I always use "rst" for my recordsets.

I don't think "rs" is a reserved phrase. My theory at first was that the autocomplete feature may require at least 3 letters in order to work, but I gave some controls random 2-letter names (and even on named "rs") Autocomplete worked just fine on all of them.

This is a very interesting issue.

--------------------------------
Ben

"It's my way, or the Hemingway."
--------------------------------