如何显示组合框中的所有可用项目？ [英] How to show all available items in combobox?
问题描述
您好！我正在使用Access 2010.我已经创建了一个找到记录的组合框。根据选择，选择选择是客户姓氏。它工作正常，但我在列表上有大约90个名字，虽然我已经增加了列表行。值为90，我得到一个我必须滚动的列，因为90行不适合屏幕。我想要做的是弹出所有名称的列表，所有名称都可见，这可能意味着3列30（因为30行适合屏幕），所以我可以通过2次点击获得任何名称而无需滚动。我的列表永远不会比这长得多，所以有一天屏幕上不会有1000个名字的危险。很多搜索都会让我看到显示多个列的信息，每个列都有不同的字段，但我没有发现任何关于包装的信息。将单个字段列表分成多个列。
提前感谢！
Hello! I''m using Access 2010. I''ve created a combobox that "finds a record" based on a selection, the selection choice being client last name. It works fine, BUT, I have about 90 names on the list, and although I''ve increased the "List Rows" value to 90, I get one column that I have to scroll through, as 90 rows don''t fit on the screen. What I want to do is pop up a list of all the names, all visible, which would presumably mean 3 columns of 30 (since 30 rows fit on the screen), so I can get to any name in 2 clicks with no scrolling. My list will never get significantly longer than this, so there is no danger of someday having 1000 names on the screen. Lots of searching keeps bringing me to info on showing multiple columns each with a different field, but I''ve found nothing about "wrapping" a single field list into multiple columns.
Thanks in advance!
推荐答案
对于ACC2010及更早版本：列包装，可以没有使用当前的默认控件。
据我在ACC2013中看到，这仍然适用。
因此，最好的我的知识，你运气不好，除非有我不知道的第三方控件，activex或API调用。
For ACC2010 and older: Column wrapping, can not be done with the current default control.
As far as I''ve seen in ACC2013, this still hold true.
Thus, to the best of my knowledge, you are out of luck, unless there is a third party control, an activex, or an API call that I am unware of.
谢谢你zmbd。鉴于此，对于如何实现我的目标还有其他想法吗？我有一个主列表拆分形式，顶部有客户详细信息，底部有数据表（或侧面，视具体情况而定）。我一直在滚动数据表来选择我想要的客户端。目前的组合框效果更好，因为我可以同时看到比数据表更多的名称，因此滚动较少。这不是关键任务;我只是希望最后一次飞跃点击并显示记录详细信息。再次Thansk！
Thank you zmbd. Given that, are there any other ideas for how to accomplish my goal? I have a "master listing" split form, with client details on the top, and the datasheet on the bottom (or the side, depending on circumstances). I have been scrolling through the datasheet to select the client I want tosee detials on. The current combobox is better, becuase I can see more names at once than on the datasheet, so there is less scrolling. This is nothing mission-critical; I was just hoping to make that last last leap to "click-click" and the record details appear. Thansk again!
嗯......
就个人而言，我希望父表单是客户端，然后子表单是所选客户端的详细信息。
IE：在实验室中：父表单链接到内部/外部客户。子表单通过customer_pk / fk相关字段链接，因此子表单仅显示与该客户相关的样本表中的记录。我在子表单上有一个切换，它将显示的记录仅过滤为打开的样本。子记录有一个点击事件，然后打开与样本相关的表格，等等。
但是，我也有办法根据ID直接搜索样本...输入时的样本已分配ID代码。使用该代码将用户直接带到该样本的数据条目
至于cbo：
我通常会打开on。我的cbo的autoexpand属性;因此，当我在文本框部分输入条目时，它开始填写。
例如，一个带有列表的cbo我的供应商公司名称...如果我在f中输入明星的名字。然后是以f开头的列表中的第一个条目。填充，如果我打开，那么我可以看到剩余的f。条目，如果我输入fi然后用fi填充第一个。通过列表中删除...当然，当记录源按字母顺序排序时，这种方法效果最好。
您可能还想查看此列表中的链接。我知道他们并不完全是你的想法;但是，这里有些东西可能有助于采用不同的方法：
-filtering-
Hmm...
Personally, I would have the parent form be the client and then the child form be the details for the selected client.
IE: In the lab: Parent form is linked to Internal/External customers. The child form is linked via the customer_pk/fk related fields, thus the subform shows only the records from the sample table related to that customer. I have a toggle on the subform that will filter the shown records to only those samples that are "open." The child records have an on-click event that will then open the form related to samples, and so forth.
However, I also have a way to directly hunt the sample down based on ID... the samples when enterd have an ID code assigned. Using that code takes the user directly to that sample''s dataentry
As for the cbo:
I usually turn "on" the autoexpand property of my cbo; thus, as I type the entry into the textbox portion, it starts to fill in.
For example, a cbo with a list my supplier company names... if I star typing in "f" then the first entry in the list starting with "f" fills, if I have drop open, then I can see the remaining "f" entries, if I type in "fi" then it fills in the first with "fi" and drops thru the list... of course this works best when the record source is sorted alphabetically.
You might also want to take a look at the links in this list. I understand they''re not exactly what you have in mind; however, something here may help with a different approach:
-filtering-
- Microsoft Access / VBA Insights Sitemap
- How to select Records in an Access Subform from a Combo Box
- Cascaded Form Filtering
- Multiple Combobox Filter with Clear Option
- Example Filtering on a Form.
这篇关于如何显示组合框中的所有可用项目？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
