K
Katherine
I have combo boxes in a form that are bound to fields in a table. I want to
be able to type values in them and have them AutoExpand.
However, Excel won't let me do this. In order to set the LimitTo List
property to "no", I have to have it display multiple fields for the box
instead of just the one I'm interested in. Otherwise I get an error message,
"The first visible column, which is determined by the ColumnWidths property,
isn't equal to the bound colum. Adjust the ColumnWidths property first, then
set the LimitTo List property."
Even when I only include one column in the ColumnWidths property, two
columns show up in the drop-down menu for the combo box.
How can I make this work?
Thanks,
Katherine
be able to type values in them and have them AutoExpand.
However, Excel won't let me do this. In order to set the LimitTo List
property to "no", I have to have it display multiple fields for the box
instead of just the one I'm interested in. Otherwise I get an error message,
"The first visible column, which is determined by the ColumnWidths property,
isn't equal to the bound colum. Adjust the ColumnWidths property first, then
set the LimitTo List property."
Even when I only include one column in the ColumnWidths property, two
columns show up in the drop-down menu for the combo box.
How can I make this work?
Thanks,
Katherine