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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. 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..

    20 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 →
  3. 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

    13 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. 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.

    10 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 →
  5. Put a button on all Reports to allow them to be closed

    The button should be at the top and not be visible on the printed report.

    Users are perplexed when there is no obvious way to close a Report in Print Preview. The Ribbon may not be visible and users may not realise they can Right Click to show the Context Menu.

    9 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 →
  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. 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 →
  8. Report View: Hide empty subreport

    In print preview and normal view, if a supreport is empty, it gets hidden. Please do the same for Report view.

    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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. BugFix: Report Printing to PDF in Domain Environment

    Sort out the crashing problem with Printing reports to Microsoft PDF Printer when in a domain environment.

    Access opens a report and when you try to automate the printing process to Microsoft PDF Writer it crashes intermittantly. It crashes with an MSACCESS application error event but I believe it to be related to Microsoft Print Spooler.

    Printing to hardware printers first seem to be ok, but printing to PDF or XPS first create problems when on a domain. Zero issues with same code on same OS and Office versions when in a workgroup or when the domain computer is unplugged…

    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 →
  14. Stop resizing Report and Form Labels in Design View, when editing the label's text.

    I see this in both Forms and Reports, but it's more irritating in Report Design as the labels are more likely to have visible borders. Sometimes a report gets copied and repurposed to a similar task or the definition of a data set gets updated. When you edit the text in an existing label, the border automatically collapses around the new text, making it look ugly and poorly aligned to the other neatly arranged labels on the Report/Form. I don't care if it clips, I'll resize the font from the ribbon. I don't care if it leaves extra space -…

    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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. When previewing a report enable touch screen scrolling…similar to scrolling through a PDF on a touch screen.

    When previewing a report enable touch screen scrolling…similar to scrolling through a PDF on a touch screen.

    2 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 →
  19. 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…

    2 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 →
  20. 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

    2 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 →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base