多线属性问题 [英] Multiline property problems

问题描述

我的数据库中有一列设置为备注.我正在尝试在文本框中查看数据.

I have a column in my database that is set to memo. I am trying to view the data in a textbox.

我已经在Enter Key Behavior属性中启用了 字段中的新行 ，但是记录中的所有数据现在都在显示-我丢失了什么?

I have enabled new line in field from the Enter Key Behaviour property but all the data from the record is now showing - What am I missing?

正在从列表框中提取数据，示例代码如下:

The data is being pulled from a list box, example code below:

Textbox1 = listbox.column(1)

预先感谢

推荐答案

这与文本框的EnterKeyBehavior属性无关.

This has nothing to do with the EnterKeyBehavior property of the text box.

http://allenbrowne.com/ser-63.html

行源

组合框或列表框的行来源"中的备注"字段将 截断.

A Memo field in the Row Source of a combo box or list box will truncate.

请勿在组合框或列表框中使用备注字段.

Don't use memo fields in combos or list boxes.

您需要使用其他方法来加载文本框，例如从列表框中读取ID，然后使用DLookup().

You'll need a different method to load the text box, e.g. read the ID from the listbox and use DLookup().

这篇关于多线属性问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！