Limit to List Property

[Thorson]

I have a lookup in one of my tables; I am trying to change the Limit To List
property to "No", however when I do a box pops up. The box says:

"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."

my Column Widths property set to: 2";2"
my Bound Column Property is set to: 2

 

[Klatuu]

You have two options.
Either

Column Widths property set to: 0";2"
Bound Column Property is set to: 2

or

Column Widths property set to: 2";2"
Bound Column Property is set to: 1

 

[Thorson]

Thank you!
--
Thorson

You have two options.
Either

Column Widths property set to: 0";2"
Bound Column Property is set to: 2

or

Column Widths property set to: 2";2"
Bound Column Property is set to: 1

 

[FF Diz]

I am having a similar problem but I want the bound column to be 4, after
setting the column widths, i still can't change the limit to list to No.
Please help. i just don't understand what the column widths have to do with
the limit to list also.

 

[John Spencer]

Read the error message.
"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."

Is column 4 the FIRST visible column. Your column widths would have to be set to
0;0;0
in order to make the fourth column the first VISIBLE column.

If you have set the combobox up as noted and it still does not allow you to
set the LimitToList property then post back.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County