Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2005-02-15 : 06:17:35
|
| Access2003....The Auto Expand for my comboboxes does not seem to be working ?Even if i type an entire word that i know is in the list it does not pick up on it and i have no idea why.The autoexpand is set to yes.If i place another combobox on the form and set it up in the normal fashion (with a query as rowsource) then the autoexpand for ALL comboboxes on the form work ?Alternatively if i refresh the links to the .mdb back-end then the auto expand works as well.However if i exit the front-end and go back in they do not work ????I can't fathom it out as they look as though they should be ok ?Any ideas ?====Paul |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2005-02-15 : 09:24:14
|
| problem solved.....i had the SQL Server Compatible Syntax checkbox ticked in the Tables/Queries tab under Tools > Optionsas soon as i unticked it the comboboxes all worked properly.i guess it is something to do with the way the list is searched whilst being typed into and the SQL syntax it uses.====Paul |
 |
|
|
|
|
|
Combobox Auto Expand problem