Sorting a simple grid style report

[SBCUser666]

Access 2007.

I have a simple report (no vba code) that selects all data in the table and prints it in a format like an Excel sheet. If I click on an entry in the report I can then filter by that column to shorten the report.

I cannot figure out how to get the sort options in the filter panel to be active so I can sort on the column.

 

[bulrush]

I don't know about A2007, but in A2003 anything on a report is read-only, including all controls, so you cannot change or filter anything.

An Access report is intended to be read-only. You do your programming behind the scenes, but when you preview the report, you cannot change any filtering, sorting, or anything else.

 

[SBCUser666]

Looking at what I created it is not called a Report. It is called an Unrelated Object. See picture for filter options.