General discussion


Access Report Sorting & Grouping box

By john.a.wills ·
I want the box empty, because I am setting OrderBy with VBA, following instructions the user gives in the form which starts the report. Somehow something has got into the box, and this upsets my sorts. I can change what's there, but I think I really need to clear the box out to allow programmatic ordering. There are no sorts in the underlying query, but there were earlier, and that may be where the Sorting & Grouping box got values from.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DeskTroll In reply to Access Report Sorting & G ...

I assume that you want the report sorting and grouping box empty.

If so, open the sorting and grouping box and select the sort level (the same as selecting a record in a table) then hitthe delete key.

Collapse -

by john.a.wills In reply to

I should have thought of that myself, but somehow I didn't. I had thought of a cluge, but now I won't have to use it.

Collapse -

by john.a.wills In reply to Access Report Sorting & G ...

This question was closed by the author

Related Discussions

Related Forums