Listbox Lines

  • Thread starter Thread starter DS
  • Start date Start date
DS said:
Anyone know how to kill those lines that divided the columns in a listbox?
Thnaks
DS

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
 
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
That sounds Very Interesting, I'll give it a try!
Thanks
DS
 
DS said:
Anyone know how to kill those lines that divided the columns in a listbox?


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.
 
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.
The Unbound listbox is for display purpose only, so it might work...I'll
let everyone know.
Thanks
DS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is This OK 2
2 Listboxes 4
List box record-line numbering 2
Listbox and Fonts 2
2 Line ListBox 2
Listbox Quandry 2
Font in Listbox 2
Access 2003, how do I know if a listbox has no row selected? 2

Back
Top