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.

5 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Paul Stoessel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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