Things that make you go hmmmmmm........?

J

JasonS

Hello everybody!
Hoping that someone will be able to answer this question since guys from
Microsoft were not able to do that.....
I've designed a database with few forms. On one of them there is a combo box
which takes its values from a record in table.
This database was designed in Access XP, and everything workd fine in that
version of Office. Users are able to type let's say first characters in this
combo, and Access is finding similar words from underlaying recordset. But,
when I start this application in Access 2000 Runtime environment on client's
computers, users are only allowed to choose from values given in list of
this combo. They are not able to write anything in this combobox. I would be
very grateful if you could tell me what this is all about...
The system is Win2K Prof, with Jet 4.0 service Pack 8 installed, as well as
ADO 2.1, and all patches regarding OS and Office 2000.
Help me, please!!!
Greetings, and thank you in advance
 
J

John Vinson

I've designed a database with few forms. On one of them there is a combo box
which takes its values from a record in table.
This database was designed in Access XP, and everything workd fine in that
version of Office. Users are able to type let's say first characters in this
combo, and Access is finding similar words from underlaying recordset. But,
when I start this application in Access 2000 Runtime environment on client's
computers, users are only allowed to choose from values given in list of
this combo. They are not able to write anything in this combobox. I would be
very grateful if you could tell me what this is all about...
Click to expand...

I suspect that somehow the combo box's Limit to List property got
switched from No to Yes somewhere in the transition. If Limit to List
is true, the user can only select existing values; if it's false, they
can type anything they want (in addition to selecting existing
values).


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
V

Van T. Dinh

(some guesses / ideas only)

1. Did you use the AddItem method in your code?

AddItem was introduced in A2002. This won't work in A2000.

2. Check the NotInList Property and AutoExpand Property
of the ComboBox.

3. ADO 2.1 is a bit out of date. I think the current
version is 2.8.

HTH
Van T. Dinh
MVP (Access)
 
Top