Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

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. enable a custom sort order in reports/queries

    I have a report which sorts on the sort field alphabetically, but I do not want this. I need to define that the following sort is carried out but I can only sort in an ascending or descending order without adding a lookup to another table or altering my item names containing the following:

    In progress
    Not started
    Ongoing
    Waiting for someone else

    If I sort alphabetically they end up as

    In Progress
    Ongoing
    Not Started
    Waiting for someone else.

    Not started is more important to me than ongoing, so I would like it to appear before Ongoing, but the…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  2. Improve Access charting, or improve the interaction with Excel

    I have a need to place a fairly complex chart in an Access report, and I wasn't able to create the chart in Access so I did it with Excel. The data actually resides in SQL Server, and there is a data connection that runs a stored procedure to bring it into Excel. This works find if you manually refresh the data in Excel, get the chart to refresh in Excel (which doesn't seem to work as easily as it should), and save the spreadsheet. If you then run the report the linked chart will work correctly. But when you…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  3. label alignment (particularly checkboxes)

    Please could you add non-VBA functionality to reports to enable us to choose where a label (particularly checkboxes) is positioned?

    I amconstantly frustrated at having to manually move the checkbox to the right of the label because it defaults to the opposite way to every other label!

    I note that Checkbox Alignment is being reviewed for future consideration (https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10129926-checkbox-alignment) but the wording doesn't mention my suggestion above and I hope it can be incorporated.

    Thank you

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  4. Putting a softkey in access to convert form to report

    Its good to have a softkey in access to convert ( form) to (report ) so we don't have to design a report that have same shape and design aspect.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  5. Cannot change report font when forecolor is set to automatic (black)

    Cannot change report font when forecolor is set to automatic (black), because after changing the font and saving the report in design view, changes won't save and the font will default back to Arial.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow emailing of Reports in Stand-alone Access 2016

    Emailing Reports from Stand alone Access 2016 no longer works if installed after March 2018. The workaround is to use Office 365.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add a property "New Sheet" for duplex printing

    Similar to the new page property, it should be extended to allow a new sheet. Otherwise, you may get in duplex print scenarios information onto the back of your sheet that has got nothing to do with the front page.
    In normal print, there would be no difference to the new page property, but in duplex print it would insert a blank page to start the next record on a new sheet.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  8. Line Methode in the normal view of a report

    it should be possible to use the line method not only in the print preview. It would be good to use it in the acViewNormal of an report or form.

    e.g. it would be possible to create a grid ... also in the interactive normal view (not only for the print preview).

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support PDF output with password encryption like Word

    We should be able to generate reports as PDFs with a password. MS Word has an encryption option when saving a Word Doc to PDF.

    For security reasons, more and more organizations want to have encrypted data at rest and in emails. ACCDBs support encryption, so it'd be helpful if it's PDF outputs could too.

    It should be available from the user interface and as an option programmatically (DoCmd.OutputTo acFormatPDF).

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. Interactive Reports

    Many of my Clients ask for interactive reports for example the ability to change a Manager name by means of a Combo box, but still have the facility to print in a nicely formatted way. It is more intuitive than having to enter criteria in a form which the user then has to click on to see the corresponding report.

    This feature will also make reports easier to use for the semi-skilled Access User and provide a much more powerful Reporting System..

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  11. Export Report to Word as Good As PDF.

    It's an Office Product! should a PDF export look better than your own product? I do not even know why Reports have the ability to export to word because they look horrible! I think it would be better if you just took away that feature all together if your not going to fix it... because really who exports to Word when it looks like that?

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  12. explain what's wrong

    in my access form, there was a yellow triangle caution symbol to the left of the minimize, shrink, and close. I didn't know what's wrong. so I suggest when you put your cursor over that symbol, Access tells you the problem.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  13. Thousands of unique images on Access reports

    Let's say you have a folder full of 4000 dpi x 3000 dpi images and a table with records containing the full path to said same.

    Now you build a nice little report with a 4" x 3" image control on it in the Detail section, with a couple of columns.
    Next bind the report to the table full of paths.
    Throw on the controls from the field(s) that have the path.
    Then build a Detail_Format event that will set the Image control's .Picture property to the path.

    Try to preview your report.
    How long before the report no longer…

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  14. MS Access

    On opening reports the ribbon is always visible. Please provide ability to set ribbon default to collapse.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow non aggregated chart functions...

    Currently we can't combine Axis fields that group by date with Value fields that don't use aggregate function in the New charts for O16.

    You could in the old charts....

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  16. Please provide a tool to create self adjusting boxes in a Report. E.g: Invoice and Quotation type of reports

    Hello Team,
    We develop CRM applications which has one major function of creating OFFERS/QUOTATIONS & Invoices which are emailed directly to a customer.
    As you are aware such type of a report is directly based on a Master/Detail table format. We need a tool in the report to create self adjusting boxes for the details section of the report. So as the list of products increment in the details section the box automatically justifies itself without losing its look n feel. Please also be aware that I'm not speaking of the "Arrange" menu which gets activated in the Reports Layout…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  17. vertical text orientation

    The Vertical Text property rotates text 90º but it is not possible to rotate 270º or other. There are many people searching for this feature over the internet for years now, but there has been no solution for this feature built in access until now. There are many workarounds, but very complicated. Hope more people find this usefull

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  18. I found out possibly a bug

    I posted 2 textboxes and command button at new MS Access reports. (I wanted to a criteria date from/date to). When I moved from om one text box to another or just click a button text disappeared. When I started to debug I found out that textbox. value = null. Only way to keep a data in text box write following code

    Private Sub txtEndDate_Exit(Cancel As Integer)
    txtEndDate.Value = txtEndDate.Text
    End Sub

    If I use a mask for dates (99/99/0000;0;_) and use this code I get a mess.

    I always use form to change criteria but somebody asked if I…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow Form/Report Wizard Design to Reopen for Edits

    I think this would be an easy one! Given the helpfulness and ease of use of the report/form wizards, there should be a simplistic way to be able to go back to those menus and make edits as needed.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  20. Make Reports Into There Own File Format Like .RPT

    Microsoft Access is pretty nice when it comes to reporting. The biggest drawback with reporting in a production environment is that it is bound to the application... i.e. many times customers want a small change on reports and you have to distribute a whole new version just to make a minor change that may have only taken 5 minutes! You should give Access report the ability to be exportable into a file format like SSRS or Crystal... this way we can edit and replace reports without having to re version the full applicaton.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Feedback and Knowledge Base