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:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
SUGGESTED COURSE:
Search Seminar: [ Ссылка ]
LINKS:
Intro to VBA: [ Ссылка ]
OnClick Event: [ Ссылка ]
Access Developer 1: [ Ссылка ]
OTHER COURSES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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.
![](https://i.ytimg.com/vi/nWNOlMiXjLc/maxresdefault.jpg)