Sorting Columns

  • Thread starter Thread starter ChrisM
  • Start date Start date
C

ChrisM

Hi Group!

Hope someone can help.

I have a FORM that is being displayed in 'Datagrid' view.
When running in the normal Access environment, you can right-click on the
tops of the columns and sort the grid by any column.

However, when running under Access Runtime (ultimately how the application
will be run), this functionality is not available.
I didn't think this would be a problem, I would just write some code to
catch a click on a column header and do the sorting myself...

Problem is, I can't find an event/property of the Form Datagrid View that I
can use to work out which column has been selected/clicked on.

Anyone got some suggestions on this?

Many Thanks,

ChrisM
 
On my website (see sig below) is a small sample database called
"ListBoxSorting2k.mdb", which illustrates one way possibility. In addition
to showing how to sort a listbox, there is also a subform example. You
can't use the Datasheet view, but you can use the Continuous View formatted
like a datasheet.
 
Thanks for your response Roger.

I'm not sure if this will work though, I don't really want to change the
view if I can help it. It is an inherited database, and I would imagine that
changing the default view of this form would have all sorts of nasty effects
on code in other parts of the system...

I'll give it a go though, watch this space!

Cheers,

ChrisM
 
Back
Top