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.
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
MS Access
On opening reports the ribbon is always visible. Please provide ability to set ribbon default to collapse.
4 votes -
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 -
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 elseIf 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
- Don't see your idea?