Formated DropDown List

[James Doughty]

Does anyone know of a way to DropDown list display 2 columns and make the
columns widths match up
i.e.

James Doughty
Matt Ellison
Phillip White

I would appreciate any ideas.

Thanks,
James Doughty

 

[Pat]

James try doing it using SQL like:-
select me, RTRIM(Name) + ', ' + RTRIM(lastname) as people from comapny
Hope that helps
Patrick

 

[James Doughty]

I did something like that but was hoping to have a better, but the
problem below is that the columns don't align up. I don't know the
lengths and they have to match up. It can be done by finding the longest
string and adding spaces at the end.
A better sample would be:

Account Agency
234233 Internal Revenue
34233 Internal Admin
....... ..............

Thanks,
James Doughty