By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Access 2007 - subform display sort option

P: 10
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.
Apr 4 '08 #1
Share this Question
Share on Google+
4 Replies


Megalog
Expert 100+
P: 378
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.
Apr 4 '08 #2

mshmyob
Expert 100+
P: 903
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,
Apr 4 '08 #3

P: 10
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.
Apr 7 '08 #4

P: 10
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...
Apr 7 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.