Highlight Sorted & Filtered Columns in Continuous Forms
This video demonstrates how to highlight sorted & filtered columns in continuous forms
For more info, see my articles: https://isladogs.co.uk/sort-continuou... and https://isladogs.co.uk/highlight-filt...
Times:
0:00 Intro
0:33 DEMO - Two very similar forms
0:44 Continuous form with sort buttons
1:41 Filter columns
2:28 Form with transparent buttons to mimic appearance of standard continuous form
3:05 VBA code - when form loads, it runs InitialiseForm procedure to set initial sort order, highlight sort columns and summarise sort info on form
3:28 GetRecordSource procedure - manages form SQL
4:02 GetOrderBy function runs when any column header is clicked to sort by that column. Adds yellow colouring to column & updates sort summary. Also adds up/down arrow to button caption of sorted column
6:02 CheckFilterFormat in modFilter checks the filter string, adds green highlighting and updates filter criteria summary info
6:25 Summary
6:48 Thanks for watching. Please like, leave a comment & subscribe.