Change Limit to List to "No"

[BarbS via AccessMonster.com]

I need to change the look-up field in a form to "LimitToList" to "No", but I
keep getting the message:

"Microsoft Office Access can't set the Limit to List Property to No right now.
The first visible column, whcih is determined by the column widths property,
isn't equal to the bound column. Adjust the column widths property first,
and then set the LimitToList property."

I have tried to change all the column widths starting with the original table,
but i can not make it work. Can someone help me with this? Thank you, Barb

 

[Duane Hookom]

Try provide us with these properties of your combo box

Control Source:
Data type of Control Source:
Column Count:
Bound Column:
Row Source:
Column Widths:

 

[Allen Browne]

You will not be able to change Limit To List to Yes unless the Bound column
is the first visible (non-zero-width) column.

A typical combo might have properties like this:
- Row Source: Select ID, Category FROM Categories;
- Column Count: 2
- Column Widths: 0";1"
- Bound Column: 1
- Limit To List: Yes

In this example, the bound column is the first one (the ID number), but it
is zero-width so the category name is displayed. Since the bound column is
zero-width, you cannot change Limit To List to No.

To work around this, provide a way that new values can be added to the
categories table as they are typed into this field. Here's how:
Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

If you don't want to do that, a less desirable solution would be to drop the
ID number from the Categories table, and make the text field the primary
key. Your main table will then have a Text field for the category also. So
the combo's properties can be:
- Row Source: Select Category FROM Categories;
- Column Count: 1
- Column Widths: 1"
- Bound Column: 1
- Limit To List: No

 

[BarbS via AccessMonster.com]

Thank you Allen for answering so quickly. It worked making the bound column
the PK., but it should not be the PK so I'll work on your other suggestions.

I have so much to learn, it's really fantastic being able to get help.
Again, Thank you, Barb

You will not be able to change Limit To List to Yes unless the Bound column
is the first visible (non-zero-width) column.

A typical combo might have properties like this:
- Row Source: Select ID, Category FROM Categories;
- Column Count: 2
- Column Widths: 0";1"
- Bound Column: 1
- Limit To List: Yes

In this example, the bound column is the first one (the ID number), but it
is zero-width so the category name is displayed. Since the bound column is
zero-width, you cannot change Limit To List to No.

To work around this, provide a way that new values can be added to the
categories table as they are typed into this field. Here's how:
Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

If you don't want to do that, a less desirable solution would be to drop the
ID number from the Categories table, and make the text field the primary
key. Your main table will then have a Text field for the category also. So
the combo's properties can be:
- Row Source: Select Category FROM Categories;
- Column Count: 1
- Column Widths: 1"
- Bound Column: 1
- Limit To List: No

I need to change the look-up field in a form to "LimitToList" to "No", but
I

[quoted text clipped - 11 lines]

but i can not make it work. Can someone help me with this? Thank you,
Barb