Results 1 to 4 of 4
  1. #1
    data808 is offline Noob
    Windows 7 32bit Access 2007
    Join Date
    Aug 2012
    Posts
    727

    Split form Datasheet Sort from A to Z

    I noticed that a couple of my columns seems to have a tiny sorting arrow showing. I did not even know it was there until now. I tried right clicking and then clicking on the same sort option that seems to be highlighted but was not able to remove the tiny sorting arrow. Does anyone know how to take this off of my columns?

  2. #2
    data808 is offline Noob
    Windows 7 32bit Access 2007
    Join Date
    Aug 2012
    Posts
    727
    Figured this one out myself. Have to go into the sheet properties and look under the Data tab and remove the filter property. I think this is set when you right click on the datasheet column heading and sort by ascending or descending A - Z then this setting is saved and will always be there until you go in and remove it from the property sheet..

  3. #3
    Missinglinq's Avatar
    Missinglinq is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Thank you for posting your solution; it may help out someone else who is having a similar problem and arrives at this post through a search!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    data808 is offline Noob
    Windows 7 32bit Access 2007
    Join Date
    Aug 2012
    Posts
    727
    No problem. I try to post a solution if possible. Its the least I can do for giving back to the community that has helped me so much. Thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Split Form with Datasheet on bottom
    By data808 in forum Queries
    Replies: 6
    Last Post: 02-19-2014, 03:05 PM
  2. Replies: 13
    Last Post: 08-22-2013, 02:37 PM
  3. Code to sort data shown on a split form
    By meissnerb in forum Programming
    Replies: 1
    Last Post: 05-03-2012, 04:34 PM
  4. Datasheet view of Split Form in a Tab??
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 12-19-2011, 04:37 PM
  5. Formatting split form datasheet portion
    By SpaceEd in forum Forms
    Replies: 5
    Last Post: 10-19-2011, 11:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums