Auto complete stopped working

[RobGMiller]

Access 2003.

Auto complete was working with a combo box. After adding much functionality
to a database I find that auto complete does not work on any combobox in any
form. So I create a blank database and a simple test shows that auto complete
works. When a form from the faulty database is imported in the test database,
auto complete stops working on the test form. Even if the imported faulty
form is removed, auto complete still does not work.

I tried creating a new database and importing the faulty form after removing
all controls and events from the form except for the combo box. Auto complete
still stops working. Not only on the imported form but also on the existing
form which works prior to the import.

I checked auto expand and it is 'Yes' in all conditions.

What ever is causing the problem on the faulty form seems to cause some
property of the database to change.

Is there some database option or property setting that controls auto complete?

Is is possible that importing a form will cause a database property to change?


--
RobGMiller

 

[fingers]

Could it be this bug in Access?

I had a similar problem and found this article which provided a solution, only after hours of trawling the web for answers.

http://support.microsoft.com/kb/824189/en-us?spid=2509&sid=285

I hope it works for you.

Rich

 

[daliborpuljiz]

Re: Could it be this bug in Access?

I had a similar problem and found this article which provided a solution, only after hours of trawling the web for answers.

support.microsoft.com/kb/824189/en-us?spid=2509&sid=285

I hope it works for you. Rich

Thanks, you've just saved me tons of time.
It is working now, too, and it's exactly caused by switching over to ANSI-92.