If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change Limit to List to "No"
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200811/1 |
#2
|
|||
|
|||
Change Limit to List to "No"
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: -- Duane Hookom Microsoft Access MVP "BarbS via AccessMonster.com" wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200811/1 |
#3
|
|||
|
|||
Change Limit to List to "No"
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "BarbS via AccessMonster.com" u36617@uwe wrote in message news:8cf42cc7b23d4@uwe... 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 |
#4
|
|||
|
|||
Change Limit to List to "No"
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 Allen Browne wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200811/1 |
Thread Tools | |
Display Modes | |
|
|