在组合框中显示超过255个字段 [英] display more than 255 char field in combo box

问题描述

大家好，


我在这里有一个问题，也许有人可以提供一些好的信息或建议。


在Access中表单我创建了2个组合框，一个是Activity组合框，另一个是Condition组合框。

当我选择Activity组合框值时，我的Condition组合框将显示Condition对应的所有描述到我选择的活动。 （这是我希望得到的）


我遇到的问题是当我选择Activity组合框值时，Condition组合框只能显示某些值，我认为这是因为组合框尺寸有225长度的限制，我认为我的条件值超过225.


所以我现在该怎么办才能得到我的条件框显示我在条件表上设置的所有值。


请随时询问我是否有任何疑问。


非常感谢。


Ray

解决方案

Hi Ray


我假设你的条件字段是备忘录。这将是一个问题，因为我不认为您可以在组合框中显示备注字段，因此Access默认为最大长度为255的文本字段。如果你解释你想要做什么以及为什么我们可以建议一个替代方案。


玛丽

嗨玛丽，

我的数据库就像当用户选择活动组合框中的一个活动时让我们说露营时，当选择露营值时，条件组合框将显示所有需要的条件它适用于露营，如C1，C2，C3等。然而，用户想知道什么是C1，C2，C3代表，这就是为什么我想让用户知道每种不同的条件描述，而不是只显示C1，C2和C3。


干杯

Ray

Hi Ray


在表单上放置一个文本框（txtDesc），在条件组合的AfterUpdate或OnChange事件中输入以下内容：

展开 | 选择 | Wrap | 行号

Hi all,

I have got a question here perhaps someone can provide me some good information or suggestion.

In the Access Form I have created 2 combo box one is Activity combo box, the other is Condition combo box.
When i select on Activity combo box value, my Condition combo box will display all the descriptions of the Condition corresponding to the Activity i have selected. ( this is what i wish to get)

The problem i have encountered is when i select on Activity combo box value, the Condition combo box will only be able to display the certain of values, i think it is because Combo box size has a limitation of 225 length, i think my condition value is more than 225.

So what should i do now in order to get my condition box display all the values which i have set on the condition table.

Please feel free to ask me if have got any queries.

Many thanks.

Ray

解决方案

Hi Ray

I assume your condition field is a memo. This is going to be a problem as I don''t think you can display a memo field in a combo box so Access is defaulting to a text field with a 255 maximum length. If you explain what you are trying to do and why we may be able to suggest an alternative.

Mary

Hi Mary,

My database is like that when user choose on one of the activity from the Activity Combo Box lets say "Camping", when Camping value is selected the Condition Combo box will show all the condition which need it for Camping such as C1, C2, C3 and so on. However user would like to know what are C1, C2,C3 stands for, that''s why i would like to let user know the each different description of condition instead of only showing C1, C2 and C3.

Many thanks.

Cheers
Ray

Hi Ray

Put a textbox (txtDesc) on the form and in the AfterUpdate or OnChange event of Condition combo put the following:

Expand|Select|Wrap|Line Numbers

这篇关于在组合框中显示超过255个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！