Access 2007 - subform display sort option

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hausj0dw
    New Member
    • Aug 2007
    • 10

    Access 2007 - subform display sort option

    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
    Recognized Expert Contributor
    • Sep 2007
    • 378

    #2
    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.

    Comment

    • mshmyob
      Recognized Expert Contributor
      • Jan 2008
      • 903

      #3
      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,

      Comment

      • hausj0dw
        New Member
        • Aug 2007
        • 10

        #4
        Originally posted by 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.

        Thanks for the reply.

        Comment

        • hausj0dw
          New Member
          • Aug 2007
          • 10

          #5
          Originally posted by 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,

          Thanks for the reply...

          Comment

          Working...