String With fixed Length

[Agnes]

i use myreader to get the data, and I want to display in the listbox .
myReader.item("productname) & " - " & myReader.item("color")
Some product name got 15 chars , some is 25 chars.
How can I display it in fixed lenght. e.g 30 chars ?
I want my data display like
TOYS RED
TELEPPHONE BLUE
....... RED
^^^^^^^^^^^^^^^^
FIXED COLUMN.
I CANNOT USE DATAGRID, BECUASE, i NEED TO SELECT FROM 5 different tables.
That's why I use Listbox.
thanks a lot.

 

[Ken Tucker [MVP]]

Hi,

I think a listview with it view set to details would be a better
choice because it has columns.

http://msdn.microsoft.com/library/d...en-us/vbcon/html/vbconaddingcolumnheaders.asp


Ken
-------------------
i use myreader to get the data, and I want to display in the listbox .
myReader.item("productname) & " - " & myReader.item("color")
Some product name got 15 chars , some is 25 chars.
How can I display it in fixed lenght. e.g 30 chars ?
I want my data display like
TOYS RED
TELEPPHONE BLUE
....... RED
^^^^^^^^^^^^^^^^
FIXED COLUMN.
I CANNOT USE DATAGRID, BECUASE, i NEED TO SELECT FROM 5 different tables.
That's why I use Listbox.
thanks a lot.

 

[J L]

Won't the padright function do this for you?

John