ComboBox问题：错误消息=您输入的文本不在列表中。 [英] Issue with ComboBox: error message= The Text You Entered isn't on the list.

问题描述

所以我有一个组合框从我的访问2010数据库中的表中提取数据。 数据有两列。 第一个是recordID，第二个包含用户要选择的文本（第1周......周x）。在组合
框的属性中，列数= 2，列宽= 0" ;; 1.5"。 创建新记录时，数据库字段没有默认值。 此组合框最初是在Access 2003数据库中创建的，并导入到干净的2010版本中。

So I have a combobox that pulls data from a table inside my access 2010 database.  The data has two columns.  The first is the recordID and the second contains text which the user is to select (Week 1... Week x) . In the properties for the combo box, column count =2, column width = 0";1.5".  There is no default value for the database field when a new record is created.  This combo box was initially created in an Access 2003 database and imported into a clean 2010 version.

表单上的行为：因此，当输入新记录时，我将记录到这个特殊的组合框。 当我进入组合框时，我将开始输入列表中的各种值之一"我们"。例如。 组合
框不会选择或自动填充任何可能的匹配。 当我继续输入时，请说完全键入"第2周"。并按Tab键进入下一条记录，我收到错误消息"您输入的文字不在列表中。" 如果我点击
展开下拉框，它显然在列表中，我必须选择文本才能填充该字段。

The Behavior on the form: So when the new record is entered, I tab through the record to this particular combo box.  When I enter the combo box, I will begin to type out one of the various values on the list "we" for example.  The combo box does not select or autofil any potential matches.  When I continue typing, say fully type "Week 2" and hit the tab key to get to the next record, I get the error message "The Text You Entered isn't on the list."  If I click to expand the drop down box, it is clearly on the list and I have to select the text in order to have it populate the field.

任何想法导致此行为的原因是什么？

Any ideas on what is causing this behavior?

推荐答案

组合框的这些属性是什么：

What are these properties of the combo box:

• 行来源
• 绑定列
• 控制源

ControlSource是什么类型的字段？

What type of field is the ControlSource?

RowSource返回的第二列中是否有重复值的行？

Are there any rows returned by the RowSource that have duplicate values in the second column?

这篇关于ComboBox问题：错误消息=您输入的文本不在列表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！