Delete a column

[supervi]

I have a listbox which has a rowsource from a table. This table has over 20 columns. The listbox shows all 20 columns but i specifically want 11 columns. Does anyone know how i would do this?

Thanks

 

[RoyVidar]

Create a query with your 11 fields, and make that the lists row source (then either manually alter the column widths, column number... or recreate the list).

Roy-Vidar

 

[teddyatjorundotnet]

Explicitly define the columns you would like for the listbox. This is exactly the same as any other query, simply build the datasource to include only the fields you would like.