I have a listbox that is filled with data from a database, but only one field
shows.
Is it possible to show more fields in a listbox?
regards,
Arvid
Mark Fitzpatrick - 14 Mar 2007 03:29 GMT
Yes, set the Rows property to determine the number of rows/items to show in
the list.

Signature
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
>I have a listbox that is filled with data from a database, but only one
>field
[quoted text clipped - 4 lines]
>
> Arvid
Arvid - 16 Mar 2007 09:41 GMT
I have multiple rows, but just one item per row. I would like to see in one
row/record a name and a address and ... But I have to choose one of them.
Can I show all?

Signature
regards,
Arvid
> Yes, set the Rows property to determine the number of rows/items to show in
> the list.
[quoted text clipped - 7 lines]
> >
> > Arvid
intrader - 14 Mar 2007 19:11 GMT
> I have a listbox that is filled with data from a database, but only one field
> shows.
[quoted text clipped - 4 lines]
>
> Arvid
Perhaps you can use the template capability of the listbox. You can then
put any html you need there.
Riki - 18 Mar 2007 18:31 GMT
> I have a listbox that is filled with data from a database, but only
> one field shows.
[quoted text clipped - 3 lines]
>
> Arvid
Use SQL to combine the fields that you want:
SELECT field1 + '-' + field2 AS myField FROM myTable;

Signature
Riki
Arvid - 19 Mar 2007 10:58 GMT
I changed my view like you said (but oracle syntax ) , it seems to be a quick
and easy way to solve my problem
thank you

Signature
regards,
Arvid
> > I have a listbox that is filled with data from a database, but only
> > one field shows.
[quoted text clipped - 6 lines]
> Use SQL to combine the fields that you want:
> SELECT field1 + '-' + field2 AS myField FROM myTable;