Access 2007 - 将列表框拆分为列 [英] Access 2007 - Break up a list box into columns
问题描述
我有一个问题，我不确定是否有解决方案...我在表中有一个允许多个值的查找字段，并且显示控件设置为列表框。列表框在表单上看起来很好（即一堆复选框），但我想在屏幕上同时有大约15个条目（即没有滚动条）。有没有办法将列表框拆分成列（如4列复选框）？
我尝试更改列计数值，但这似乎没有预期的效果....
I have a problem that I''m not sure there is a solution for... I have a lookup field in a table that allows multiple values and the display control is set to be a List Box. The list box looks fine on the form (ie. a bunch of check boxes), but there are about 15 entries that I would like to have on the screen at once (ie. no scroll bars). Is there any way to break up the list box into columns (like 4 columns of check boxes)?
I have tried changing the Column Count value but this doesn''t seem to have the intended effect....
推荐答案
我有一个问题，我不确定是否有解决方案...我在表中有一个允许多个值的查找字段，并且显示控件设置为列表框。列表框在表单上看起来很好（即一堆复选框），但我想在屏幕上同时有大约15个条目（即没有滚动条）。有没有办法将列表框拆分成列（如4列复选框）？
我尝试更改列计数值，但这似乎没有预期的效果....
I have a problem that I''m not sure there is a solution for... I have a lookup field in a table that allows multiple values and the display control is set to be a List Box. The list box looks fine on the form (ie. a bunch of check boxes), but there are about 15 entries that I would like to have on the screen at once (ie. no scroll bars). Is there any way to break up the list box into columns (like 4 columns of check boxes)?
I have tried changing the Column Count value but this doesn''t seem to have the intended effect....
您是否要求将单列列表框转换为4列列表框？如果是这样，单列列表框中的值是否有分隔符？你究竟想通过这样做完成什么？您是否意识到列表框的新格式仅用于显示目的？如果这是您的目标，请发布一些典型的单列列表框条目。
Is your request to convert a single column List Box to a 4 Column List Box? If so is there a Delimiter betwen values in the single column List Box? What exactly are you trying to accomplish by doing this? Do you realize that the new format of the List Box will be for display purposes only? If this is your goal, please post some typical single column List Box entries.
您是否要求将单列列表框转换为一个4列列表框？如果是这样，单列列表框中的值是否有分隔符？你究竟想通过这样做完成什么？您是否意识到列表框的新格式仅用于显示目的？如果这是您的目标，请发布一些典型的单列列表框条目。
Is your request to convert a single column List Box to a 4 Column List Box? If so is there a Delimiter betwen values in the single column List Box? What exactly are you trying to accomplish by doing this? Do you realize that the new format of the List Box will be for display purposes only? If this is your goal, please post some typical single column List Box entries.
首先，感谢您的回复。要回答您的问题，是的，我想将单列列表框转换为4列列表框，以进行纯格式化。列表框有大约15个条目，我不希望列表框中的所有项目都在一列中。由于列表框允许多个选择，它确实包含复选框。该数据库将用于跟踪光学处方，因此典型的条目（色调）将是：透明，灰色，粉红色，黄色等。如果这仍然没有意义，请告诉我，我会创建一些截图。
First of all, thanks for your reply. To answer your question, yes I would like to convert a single columns List Box to a 4 Column list box for purely formatting purposes. The List Box has about 15 entries and I don''t want to have all of the items in the list box in one column. Since the List Box allows multiple selections, it does contains Check Boxes. The database is going to be used to keep track of optical prescriptions so typical entries (for tint color) would be: Clear, Grey, Pink, Yellow, etc. If this still doesn''t make sense, let me know and I will create a couple screenshots.
首先，感谢您的回复。要回答您的问题，是的，我想将单列列表框转换为4列列表框，以进行纯格式化。列表框有大约15个条目，我不希望列表框中的所有项目都在一列中。由于列表框允许多个选择，它确实包含复选框。该数据库将用于跟踪光学处方，因此典型的条目（色调）将是：透明，灰色，粉红色，黄色等。如果这仍然没有意义，请告诉我，我会创建一些截图。
First of all, thanks for your reply. To answer your question, yes I would like to convert a single columns List Box to a 4 Column list box for purely formatting purposes. The List Box has about 15 entries and I don''t want to have all of the items in the list box in one column. Since the List Box allows multiple selections, it does contains Check Boxes. The database is going to be used to keep track of optical prescriptions so typical entries (for tint color) would be: Clear, Grey, Pink, Yellow, etc. If this still doesn''t make sense, let me know and I will create a couple screenshots.
我本来希望获得更多信息，但我想我已经足够给你至少一个代码模板来解决。以下代码将名为lstOriginal的单列列表框中的条目传输到名为lstNew的4列列表框。让我知道你是怎么做出来的：
I would have preferred a little more information, but I think I have enough to give you at least a code Template to work off of. The following code will transfer the entries in a Single-Column List Box named lstOriginal to a 4-Column List Box named lstNew. Let me know how you make out:
这篇关于Access 2007 - 将列表框拆分为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
