I have a list box and I want to be able to sort it by clicking or double clicking on the header of each column. Is this even possible?
I have 7 columns: Tracking Number, Location, Date Received, Date Moved, Date Completed, Submitted By and Submitted On.
I've attached the document.
Also, when I update the record the date formatting changes. When I save the initial record, the date format is dd-mmm-yyyy, but when I update it, it puts the date format exactly how you enter it in the date textbox.
For instance, when I save the initial record as 6/1/21, it puts it in the spreadsheet and list box as 01-Jun-2021, but when I update the record and type 6/1/21, it puts it in the spreadsheet and list box as 6/1/21.
It's not a big deal, just a minor annoyance because the date format isn't uniform.