Access 2007 - subform display sort option

[hausj0dw]

How can I rermove the sort option on columns displayed on a form.

This database is access 2003, some users have access 2007. The 2007 users want the sort option removed.

[Megalog]

I dont think you can remove the 'Sort' options.. You can remove the ability to Filter, by changing the AllowFilter property to 'No'..
But for a normal A-Z Sort, I dont see a way to disable that.

[mshmyob]

I have also never found out how to turn off the sorting (either Ascending or Descending).

I have at times needed to display records based on the order they have been entered though and I did a little work around. If that is what you need to do then this is what I do:

1. Create an AUTONUMBER field in your table (this will never be shown)
2. Sort your form based on the Autonumber (This will display all records as they were entered and not on the PK.

cheers,

[hausj0dw]

I dont think you can remove the 'Sort' options.. You can remove the ability to Filter, by changing the AllowFilter property to 'No'..
But for a normal A-Z Sort, I dont see a way to disable that.

Thanks for the reply.

[hausj0dw]

I have also never found out how to turn off the sorting (either Ascending or Descending).

I have at times needed to display records based on the order they have been entered though and I did a little work around. If that is what you need to do then this is what I do:

1. Create an AUTONUMBER field in your table (this will never be shown)
2. Sort your form based on the Autonumber (This will display all records as they were entered and not on the PK.

cheers,

Thanks for the reply...