Display query result which contains many rows of text

Hi all,

I want to display a query result which contains many rows of text (a
paragraph). I have tried to use text box. However, I found that there is no
rowsource available. I have tried to use the controlsource with my sql
statement. However, it just shows "#name?" after the query.

I would like to know how I can achieve this.

Thanks a lot!

The sql statment query the data in an external databse. The result can be
displayed in the list box. However, only part of the result is displayed
because only one row is displayed in the list box

"vv" wrote:

Hi all,

I want to display a query result which contains many rows of text (a
paragraph). I have tried to use text box. However, I found that there is no
rowsource available. I have tried to use the controlsource with my sql
statement. However, it just shows "#name?" after the query.

I would like to know how I can achieve this.

Thanks a lot!

That is the limit on a listbox. Each row is of the listbox is one line high.

If you want to display more than that, you will have to use some other solution.

Perhaps a sub form in continous mode and with a scroll bar on the control.

Perhaps an additional control that displays the multi-line text of the currently
selected item in the listbox.

Or perhaps another solution.

vv wrote:

The sql statment query the data in an external databse. The result can be
displayed in the list box. However, only part of the result is displayed
because only one row is displayed in the list box

"vv" wrote:

Hi all,

I want to display a query result which contains many rows of text (a
paragraph). I have tried to use text box. However, I found that there is no
rowsource available. I have tried to use the controlsource with my sql
statement. However, it just shows "#name?" after the query.

I would like to know how I can achieve this.

Thanks a lot!