Feedback by UserVoice

I suggest you ...

Allow Control-A to Select All in Query Design View

In previous versions of Access, I could use Control-A to select all fields in a table within the query design view, then Control-Click on the certain field(s) to de-select. It is not always preferential to use the asterisk, particularly if you are doing something other than a delete query. This used to be supported, but looks like it went away after I upgraded to Office365. Thanks.

7 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Paul Stoessel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Gerrit Viehmann commented  ·   ·  Flag as inappropriate

    In QBE-mode (design mode) double click on the table/subquery-name rectangle to select all fields (but not *).

    In SQL-text-mode try Ctrl-, Ctrl-. for a similar effect like Ctrl-A.

    But I agree, the QBE-Editor and SQL-text editors are in need of a serious upgrade.

Feedback and Knowledge Base