changing display order of table on form

[JohnW]

Hello,
I have a table displayed on a form (LIST BOX) - all good, but I want to
change the display order of the columns instead of default, which I presume
is time/date of entry.

I am sure this is a feature somewhere in properties but not sure where.

So, if I click on column B it will sort by ascending/descending.

Using office XP for office 2008

thanks,

 

[John W. Vinson]

Hello,
I have a table displayed on a form (LIST BOX) - all good, but I want to
change the display order of the columns instead of default, which I presume
is time/date of entry.

I am sure this is a feature somewhere in properties but not sure where.

So, if I click on column B it will sort by ascending/descending.

Using office XP for office 2008

thanks,

Base the listbox on a Query, rather than on the table. You can specify
whatever sort order you like on a query.

If you want the sort order user-selectable you'll need some VBA code to change
the query dynamically.

 

[Mike Painter]

Hello,
I have a table displayed on a form (LIST BOX) - all good, but I want
to change the display order of the columns instead of default, which
I presume is time/date of entry.

I am sure this is a feature somewhere in properties but not sure
where.

So, if I click on column B it will sort by ascending/descending.

Using office XP for office 2008

thanks,

John W responding to JohnW is why we don't like spaces in field names.

If you want to sort on more than one of the columns (at separate times) you
may want to consider making a subform look like a list box
You could also put command buttons above teh list box to sort on differetn
columns.

 

[JohnW]

Thanks guys, something to think about