Software

Ask something
Discussion Locked

Access Report Sorting & Grouping box

0 helpful
3 replies

by john.a.wills

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by desktroll

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.

by john.a.wills

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.

This discussion is closed to new replies.