News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, September 26, 2011

Preview Access report at 100% zoom

Now, with bigger monitors, it is better to preview report at 100% zoom, rather than fit it to screen, so you can see it at actual size, not zoomed to a whole screen. It's easy to change zoom level on preview, but such setting is missing in report design. There is a "Auto Resize" report property, which controls this, when you set it to False (No) – your report will be previewed at 100% zoom.



Tuesday, September 13, 2011

Controls do not display their Control Tips

When you have controls on a form grouped with rectangle, and want them to show Control Tips, it can happen that some controls do not display Control Tips unless you move focus in the control or click on it.


The problem is in rectangle, which z-order is above controls. To fix it - put rectangle below all controls by selecting it and using menu Format>Send to Back or ribbon Arrange>Send to Back.


Friday, September 09, 2011

Hotfix: Running query takes longer than expected

Access 2010 hotfix package (Ace-x-none.msp): August 30, 2011

Issue that this hotfix package fixes:

Assume that you run a query in Access 2010 on a computer that is running Windows 7 or Windows Server 2008 R2. In this situation, the taskbar displays "Running query" together with a process bar and it takes longer than expected to return the query results.
Note This issue does not occur if you run the query in Access 2010 on a computer that is running Windows XP.