LimitToList error -- bound column not equal to first visible colum

[Steve Vincent]

Hi,

I'm getting an error using combo boxes in a table. I get two error messages
(identical) stating:

"Microsoft Office Access can't set the LimitToList property to "No" right
now. 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."

There are about 10 combo boxes in this table, and Access (of course) doesn't
specify which fields are throwing the errors. I have gone over the
field/combo box properties with a fine tooth comb, and every single bound
column IS equal to the ColumnWidths property in every case. I have even
tried re-entering those properties. I am 100 percent certain that what
Access says is the problem, ISN'T the problem. At least it is not visible to
my searching eyes.

Any experience with this issue that might help me find the problem behind
these errors?

TIA,
Steve Vincent
(e-mail address removed)

 

[Ken Snell \(MVP\)]

The BoundColumn property should be a single, integer number, between 1 and
the total number of columns in the combobox or listbox. This property
identifies the column that contains the actual value of the control and that
can be stored into a field that is bound to the combobox or listbox.

If, for example, your ColumnWidths property were
0";1";2";0"

then the BoundColumn property would have to be 2 in order for you to use the
LimitToList property.


If, for example, your ColumnWidths property were
1";0";2";3";0.5"

then the BoundColumn property would have to be 1 in order for you to use the
LimitToList property.


If, for example, your ColumnWidths property were
0";0";1.5";1";0"

then the BoundColumn property would have to be 3 in order for you to use the
LimitToList property.