List box with a carriage return??

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a list box with the rowsource:

SELECT DISTINCTROW Customers.CustomerID, Customers.ContactName,
Customers.time, [ContactName] & " " & [Time] AS data FROM Customers;

I would like to have the Time appear below the ContactName in the list box.
Is this possible??
 
No, you can't display multi-line in a listbox.

You can certainly use a continues sub-form..that will work. If you look at
the following pictures, the firs screen shot shows a listbox on the left
side..and a continues form on the right...you will be hard pressed to
tell/see the difference.

So...use a continues form......

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
 
Albert, thanks for the reply,
I am using the list boxes to display daily data on a form that resembles a
calendar. I tried using subforms in this manner, although to show a month
at a glance I needed to display 42 subforms each with its own query per day.
It did work!!.....slowly...and would get virtual memory low errors. I
though if I used text boxes this might simplify things a bit. Might there
be another object that would work?? Thanks for the reply
 
Jeff,

You may want to look at our TList ActiveX component.
TList can be used as a List ( or tree or grid ) and
will support multiple lines in a single listbox cell.

Note - you might also use TList as a grid to show the
"calendar". So each column would be a seperate data of week,
and each row would be some week or some time during the day.

Check it out at www.Bennet-Tec.Com
Drop a note if you have any questions

-----

Jeff Bennett
(e-mail address removed)

* Bennet-Tec Information Systems, Inc
* 50 Jericho Tpk, Jericho, NY 11753
* Phone 516 997 5596, Fax - 5597
* RELIABLE Components Make You Look Sharp!
* TList/Pro * ALLText HT/Pro * MetaDraw *
* Custom Software Development Services Too.
* WWW.Bennet-Tec.Com

=================== ===================
 
Back
Top