Output All Fields property of the query to No Keeps Reverting

[accessnewbie352]

Every once in a while when I update an expression in a query, I get the error message that I cannot 'group on fields selected with '*'." I googled it and the solution was to change the output all fields property to "No". This worked for me, however it keeps reverting back to "Yes" for some reason so each time before I run the query, I have to change the output all fields back to "No". What is causing this and how do I "lock" it so it remains as "No." I am afraid the query will not run when I give it to the end-user.

[June7]

Set the "Output All Fields" in Access Options: File > Options > Object Designers > Query Design

You can always edit the query in SQL View to remove the "*".