Microsoft Access combo box unexpected behavior
I use combo boxes regularly and am very familiar with their behavior and operation. Recenly I installed Office Access 2007 and have noticed unexpected behavior with combo boxes. Usually the feature that allows you to type values into the box where it anticipates, or auto completes, the entry works as exected in design and preview mode. However, when the application is started, this feature stops working. Moreover, when I type in a valid value into the combo box, a message appears saying it does not recognize the value. Has anyone else experienced this behaviour and possibly found a way to resolve it.
Are you binding the list of possible values from a table or are they loaded directly into the dropdown?
Also, please indicate the exact error message you receive.
Are you running .mdb files in 2007, or are you using the native format? If you're using .mdb files, are these files that were created IN 2007, or have they been "converted"? If converted, there have been some strange behavior noted for some of those files, and the fix for them was to create a new, blank .mdb file in 2007 and then import all items from the old file to the new.
Are you running .mdb files in 2007, or are you using the native format? If you're using .mdb files, are these files that were created IN 2007, or have they been "converted"? If converted, there have been some strange behavior noted for some of those files, and the fix for them was to create a new, blank .mdb file in 2007 and then import all items from the old file to the new.
ASKER
The fields are bound to a query. The tables are in a seperate file from the forms, etc. Both files are 2007 .accdb files.
Following up on LSM's post, please remember that Access 2007 debuts a few new Combobox properties.
Make sure these are set correctly for what you are trying to accomplish.
untitled.JPG
Make sure these are set correctly for what you are trying to accomplish.
untitled.JPG
Is the Bound column the first visible column?
If not try moving the bound column to be the first column and then set the column width to zero (to hide it)
Cheers
JC
If not try moving the bound column to be the first column and then set the column width to zero (to hide it)
Cheers
JC
I have experienced this twice since using MS Access 2007.
How I got round the issue was to Create a new Blank Database with a different name.
Open the new database, import all forms and queries etc, (not the tables), then compact and repair.
Close the database.
Re-open it and all should be well again with the combo boxes.
It worked for me, I don't know why.
How I got round the issue was to Create a new Blank Database with a different name.
Open the new database, import all forms and queries etc, (not the tables), then compact and repair.
Close the database.
Re-open it and all should be well again with the combo boxes.
It worked for me, I don't know why.
Naturally I meant "import all forms and queries etc," from the database your having trouble with. :)
Once done, you can delete the troublesome one and rename the new dbase the same as the old one if you like.
Once done, you can delete the troublesome one and rename the new dbase the same as the old one if you like.
Also, can you post a sample of this database, with just enough data to see this issue?
ASKER
None of these suggestions has helped me to fix this issue.
As I suggested, a sample with just enough generic data to see this issue, might make things clearer
ASKER
Will do... let me get it together.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I appreciate everyone's help on this issue. It seems to be more of an anomoly than a fixable issue. When I tried recreating the problem on a new database, the issue did not exist. Thanks again.