>I have a listbox that displays city and state values obtained through an SQL statement. Everything works fine. However, I am not happy with the appearance of the dropdown box. The following is an example of what I get when I click on the listbox:
>
>Atlanta................GA
>Pensacola.........FL
>Tallahassee.........FL
>
>(ignore the dots, it was the only way I could get the spacing right)
>
>What I would like to see is this:
>
>Atlanta, GA
>Pensacola, FL
>Tallahassee, FL
>
>Is this possible? If so, how?
>
>Thanks in advance for your help,
>Russell Clendenon

Select PADR(Trim(City) + ", " + State, 40) As CityState, ...