Access (Desktop Application)

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Dedicated Lookup Control

    Just like a combo but without a drop down button and does not allow editing. It would be bound to a FK but display a selected column from the related table but not be editable and would not have a drop down button.

    This would save having to add related tables to a form's record source when you only want to display a column. And you definitely don't want to allow the user to modify it.

    An example would be on a continuous form bound to tblInvoice, The control is bound to tblInvoice.CustomerID but displays tblCustomer.CustomerName.

    This could possibly be…

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
    • Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats

      The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.

      Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.

      Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…

      24 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
      • Ctrl+A in a textbox should select all text instead of all records

        Currently, when I'm in a form's textbox and I instinctively hit Ctrl+A to select all text (just like any other Windows application), nothing happens. Or so you may think, in fact everything happens! All records get selected, and if you dare hit the wrong button while you think you have selected all text of the textbox, woe is unto you.

        Should Access really be different from all other programs out there? Why should a user think that when in a textbox and hitting ctrl+A it won't select the text?

        Of course, there are workarounds (like a VBA function that hijacks…

        4 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
        • Left Justify Caption in Form Title Bar

          In Access 2007 all form title bar captions are left justified so that when you minimize them you get some idea as to which form you are dealing with. Example would be Caption = "Main Menu" when minimized it would show "M...".
          With Access 2016 the caption is kind of center justified so when you minimize it shows nothing???

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
          • POSSIBILITY TO ADD SEGMENTS LIKE EXCEL IN A FORM

            To apply filter easily
            data source: values of the segment : sql
            child object : subform in continuous mode
            field father:child
            Sorry for my poor english

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
            • Add the possibility ta create control in tabular mode with hidden forms

              When you create new control in a new form in hidden mode, you can't use tabular mode

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
              • Custom naming on message boxes

                When using the vbYesNo message box you can only have 'Yes' or 'No' options. I would like to be able to rename these options. Currently the only way round it is to create a form to look like a message box.

                27 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  2 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                • Subform in continous form

                  Today we can't use a subform in a continous form.

                  102 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    7 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                  • Listbox update

                    Have a fully programmable listbox with events like comctl listbox and treeview we had. Sizable columns, header click, sorting, image support.

                    48 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      7 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →

                      Hi Yossi,

                      Thanks for posing on Access UserVoice.
                      We are not quite sure we fully understand the suggestion here.
                      Could you elaborate and provide more details?

                      Thanks,
                      Michal [MSFT]

                    • Make Access fully MDI

                      Although the UI of MS Access has been modernised with Office Fluent Ribbon, Access is not fully MDI - all the displayed objects - forms, tables etc.. still display within the current window. How about keeping up with Word and Excel programs, have the option for each object to display in a separate Window?

                      6 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                      • 1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                        • Redraw errors with lables while browsing through records in forms

                          Since Access 2007 there is an annoying effect regarding label texts while you are browsing through records in data driven forms. Every time you do so, some of the labels (seemingly not all of them) are redrawn with a minimal offset to their original position without removing the old pixels. This results in making the label texts bolder and bolder - very annoying!

                          There is a similar effect with command buttons using advanced formats (styles).

                          7 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                          • Include "hide control" feature Continuous Forms

                            Currently on Continuous Forms, the developer can enable/disable, along with a few other functionality items relating to conditional formatting. At the moment, there is no "hide/unhide" feature to allow developers to display or not display controls based upon values of a particular row of data. There are ways to do it, but only in a very convoluted way, and very confusing when having to manage the code. Please include this functionality for continuous forms!

                            20 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              4 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                            • Deal with sleep mode properly for tablet environments

                              When a tablet or PC goes into sleep mode any active form looses its connection to the database backend (I am using SQL Server). This is very annoying in tablet environments where the PC is frequently switched to sleep mode. Make it so that Access can detect a reawaken from sleep and refresh the connection automatically rather than leave an error so that the user doesn't have to log off and reload the screen.

                              20 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                              • Modify form and report designer to allow use to add (sub) sections (detail/group/header/footers)

                                I would find the ability to add additional sections would give greater design capability. Similar functionality to that provided in Crystal Reports.

                                3 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                • Allow developer to put animations like gif images or flash

                                  Review the shockwave flash object and put a animated gif component.
                                  An example for usage:
                                  a) We can use little flash animations in splash screens
                                  b) Animated gifs could be an option instead of progressbars (like the "loading" icons we see on web pages)

                                  We do have a shockwave flash component - but at least here I can't make it work in Access 2013). The gif idea came from a customer.

                                  8 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    3 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Macroes vs VBA in Button Wizard

                                    When using the Button wizard MS Access creates macroes as default. This should be an option if you prefeer macroes or vb as the event code.

                                    19 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      9 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Can we have a Separate Time Picker Control

                                      Often Date and Time are stored separately. To ensure the correct time is entered one has to write a fair bit of code to determine 24 hour time or AM/PM are entered correctly. A Time picker would have two Combo boxes, one for hours and one for minutes -and even show the time on a dial.

                                      6 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Improve the built in Date Picker

                                        Currently the built in date picker is useful only with inputting recent dates. Since you can only navigate month by month if the user needs to enter a date more than a few months away, it can be cumbersome to navigate.

                                        The Date picker should allow the user to select a month and year to choose the date from.

                                        Also it would be nice if one could add a time picker to a DateTime control. Either along with the date picker or instead of it.

                                        The limited usage of the current date picker forces developers to use other solutions when…

                                        36 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          8 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Create a customizable validator for textbox

                                          Access has a field validator in table designer.

                                          But in forms would be good to have, for example, predefined (and customizable) validators, like e-mail, directly on textboxes. And, instead of a message box, we can paint the control and show a tooltip with error.

                                          For reference, take a look at section "validator" in Bootstrap or Material design.

                                          Thanks!

                                          3 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Access (Desktop Application)

                                          Feedback and Knowledge Base