Listbox Lines

S

SteveS

DS said:
Anyone know how to kill those lines that divided the columns in a listbox?
Thnaks
DS
Click to expand...

How about using a calculated column?

For example if you want to display Emp#, last name, first name and dept, the
row source for the list box would have 5 columns: ID (PK),EmpNum,L_Name,
F_Name, DeptAbbrev.

Add a calculated (6th) column to the rowsource of :

AllInfo:EmpNum & "/" & L_Name & ", " & F_Name & "/" & DeptAbbrev

Set the Column widths for the first 5 columns to 0" (zero) and the width for
the 6th to maybe 3" - whatever it takes to see the full line.

Make the listbox control wide enought to see the info..

Don't forget to set the Number of Columns to 6 on the Properties/ Format tab.


HTH
 
D

DS

SteveS said:
:




How about using a calculated column?

For example if you want to display Emp#, last name, first name and dept, the
row source for the list box would have 5 columns: ID (PK),EmpNum,L_Name,
F_Name, DeptAbbrev.

Add a calculated (6th) column to the rowsource of :

AllInfo:EmpNum & "/" & L_Name & ", " & F_Name & "/" & DeptAbbrev

Set the Column widths for the first 5 columns to 0" (zero) and the width for
the 6th to maybe 3" - whatever it takes to see the full line.

Make the listbox control wide enought to see the info..

Don't forget to set the Number of Columns to 6 on the Properties/ Format tab.


HTH
Click to expand...
That sounds Very Interesting, I'll give it a try!
Thanks
DS
 
M

Marshall Barton

DS said:
Anyone know how to kill those lines that divided the columns in a listbox?
Click to expand...


If you have to maintain the columns, instead of
concatenating all the data into one string, then I suugest
using a continuous subform instead of a list box. A form
provides a lot more control over how the data is presented.
 
D

DS

Marshall said:
DS wrote:





If you have to maintain the columns, instead of
concatenating all the data into one string, then I suugest
using a continuous subform instead of a list box. A form
provides a lot more control over how the data is presented.
Click to expand...
The Unbound listbox is for display purpose only, so it might work...I'll
let everyone know.
Thanks
DS
 
Top