How to Make Click To Sort Column Headers in your Microsoft Access Continuous Forms

In this video, I'm going to teach you how to create a one-click method to sort by a specific field (column) in your Microsoft Access continuous forms.

Bernie form St. John's, Newfoundland (a Platinum Member) asks: I know you can sort the records in a form by right-clicking on the field and selecting a sort option, but that's a pain. Is there an easier, faster way to just, say, click on the column header and sort by that column? My accounting software works this way and I would love it if Access did, too.

Silver Members and up get access to an Extended Cut of this video. Members will take this up a notch. We will make one click to sort ascending (A to Z) and a second click will sort descending. We will also change the color of the column header label to blue if it's sorted ascending, and red if descending.

MEMBERS VIDEO:
   • Click to Sort Microsoft Access EXTEND...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/ClickToSort

SUGGESTED COURSE:
Search Seminar: https://599cd.com/SearchSeminar

LINKS:
Intro to VBA: https://599cd.com/VBA
OnClick Event: https://599cd.com/OnClick
Access Developer 1: https://599cd.com/ACD1

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, click to sort, How to sort in a form in Access, orderby, orderbyon, Click field header to sort Access, order by, order by on, sort by column, click on column header, on click event

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.