Asterisk is automatically being added in query - Access 2007

[klrich]

I have been using Access 2007 for a long time. A few weeks ago I noticed that when I set up a simple query using the design mode with only 2-3 fields, an asterisk is being added which will return all fields. I have to go into the SQL and take out the askerisk. Why is it doing this? It never did this before, and I tried looking at the Options so see if there is a setting but I haven't found anything.

Thanks!

[June7]

Look at Options > Object Designers > Query Design > Output all fields

[klrich]

Thank-you!!!!!! That fixed it!!!