Change LimitToList to "no" in Access 2007

[WildeYam]

I would like to add new data "on the fly" when a new item must be added to
the combo box. I tried changing the "Limit to List" from Yes to No but I
keep getting the following error message:"The first visible column, which is
determined by the ColumnWidths property, isn't equal to the bound column.
Adjust the ColumnWidths property first, and then set the LimitToList
property" Does this mean it is not equal to the WIDTH of the bound column?
I have made the ColumnWidth of the bound column the same as the combobox
width and that did not work. If that is not what was meant, then how do I
make the change? I think I have tried all the ocmbinations with no luck.

 

[Allen Browne]

Let's take an example of a combo that has the RowSource like this:
SELECT CompanyID, CompanyName FROM tblCompany;
It has 2 columns (the ID number, and the name), so it will have properties:
Bound Column 1
Column Count 2
Column Widths 0";1"

The Bound Column is 1, so the first field (CompanyID) is the value of the
combo. But the first column is zero-width, so it *displays* the company
name, even though it's really storing the CompanyID number.

You cannot set Limit to List to 'no' for this combo. That's because it
displays one value, but stores another. Consequently if you type a value
that's not in the combo, Access cannot figure out what CompanyID you mean.

Access won't let you set Limit To List to Yes, unless the bound column is
the displayed column.