list box control is crosstab 1

[JaredTaylor74]

I have a list box who's data comes from a crosstab query, is there any way to adjust the columns in the list box?

in the query i can move the "SLIDES" column to come before the "SHUTTLES" column, but in the list box, the "SHUTTLES" column comes before the "SLIDES" column. don't want it that way.

any help would be greatly appreciated.
Thanks,
Jared

 

[GingerR]

It's doing it alphabetically.
If you always have the same field names, in the query, view Properties, then put in the Column Headings whatever you want

"Slides", "Shuttles", "Rope"....whatever. But this won't work if the columns change (i.e. the next time you run it, there are now "Pants" but you don't have that in the Column Headings).

 

[JaredTaylor74]

cool thanks!

yep, will always have the same headings, so this works perfectly.

'preciate it.

Thanks,
Jared