List box with a carriage return??

[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??

 

[Albert D. Kallal]

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

 

[Jeff]

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