Resort Columns on Form (1 Viewer)

[sparklegrrl]

Good morning,

I am running Access with Office 365. I have continuous form based on a query for job applicants. The form has first name, last name, date applied, applied for, etc. How do I set it so that the columns on the form can be sorted by the user.

Many years ago, I had a database I did this on and can't remember how I did it. I think I did it through a macro and a requery?

 

[theDBguy]

Hi. Check out the OrderBy and OrderByOn properties of the Form

 

[Micron]

Are you sure this is a continuous form and not a datasheet? CF fields are usually arranged in rows but I guess they don't have to be. One way is to remove the column labels, place a button at the top of each column with the column caption instead, and when they click it, you first sort that field ascending. If they click it again, you sort descending and so on.

Or you can simply use Sorting on the ribbon?

 

[CJ_London]

have the use right click on a control in the detail section - it should bring up a short cut menu for sorting and filtering - pretty much the same as clicking on the down arrow of a datasheet column header.