Combo Box autoexpand not working.

[Rico]

Hello,

I have an Access 2002 database and I'm using combo boxes on the form. Auto
expand is set to True on the combo box, but for some reason, it's not
functioning. I have used Access for years and have never encountered this
problem.

Any ideas?

Thanks!
Rick

 

[Ken Snell MVP]

Is the form's AllowEdits property set to Yes? Do you have at least one
column visible in the dropdown list for the combo box? When you say, "not
functioning", are you able to type text into the combo box, but you're not
seeing the combo box add characters to what you've typed? Are the characters
that you're typing ones that values begin with in the combo box's dropdown
list for the first visible column?

Please list the values for the following properties:

Row Source
Row Source Type
Bound Column
Column Widths
Column Count
Enabled
Locked
Control Source
Limit to List
List Rows
List Width

 

[Rico]

Hi Ken,

"Yes" to all your questions. I have values in the list "Bow Valley" for
instance, and when I being type "Bow" (case correct or not), I would expect
the " Valley" portion to auto expand in and show "Bow Valley" in the combo
box, but it does not.

Row Source = SELECT tblMemberInstitutions.strMemberName,
tblMemberInstitutions.pkMember, tblMemberInstitutions.strMemberAbbrCode

FROM tblMemberInstitutions
ORDER BY tblMemberInstitutions.strMemberName;

Row Source Type= Table / Queary
Bound Column=2
Column Widths=3.5";0";0"
Column Count=3
Enabled=true
Locked=false
Control Source=fkMemberID
Limit to List=Yes
List Rows=8
List Width=3.5

Any help would be greatly appreciated.

Rick

 

[Ken Snell MVP]

Let's see if the control is corrupted in some way.

Delete the combo box from your form. Save and close the form. Reopen the
form in design view and put a new combo box on the form, and set it up as a
replacement for the original combo box.

 

[Rico]

It looks like SQL Syntax that was put on the database is the cause. Any
idea if I can use auto expand with SQL Syntax and how to do it?

Rick

 

[Ken Snell MVP]

If you're asking, will autoexpand work if you use a SQL statement as the
combo box's RowSource, the answer is yes. So I'm not understanding your
question here? What is it about the syntax of your SQL statement that you
think is the problem?
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Rico]

No, it's not the SQL syntax of the rowsource (sorry, I didn't add "SERVER"
at the end of SQL)

The database is using SQL Server compatible syntax.

Rick

 

[Ken Snell MVP]

AutoExpand should be independent of the SQL syntax that you use.

Can you zip up a small copy of the database and email it to me at the
address found on the web site in my signature? Provide instructions about
which form and what you do to make the problem occur, and I'll look at it as
soon as I can to see what I can identify.