Week in Review: June 20, 2026
Highlights include a deep dive into the CurrentDb() function, highlighting the current row in a continuous form, and tips for using the built-in Access progress meter.
Just Published
This section includes videos, articles, and (occasionally) open-source project updates from the past 7 days.
Articles
Article descriptions generated by Claude-Sonnet-4.5.
- Official Access Blog
- Bug fixes in Microsoft Access - Preview Version 2606 (Build 16.0.20131), by LindaLu Cannon: Fixes AltGr key input issues on German keyboards and restores zoom functionality in ACCDE/MDE files that was unintentionally disabled.
- Access begins rollout of Big Forms for Modern Monitors feature, by LindaLu Cannon: Announces beta support for forms larger than 22 inches, removing the longstanding size limitation for modern high-resolution displays.
- John Mallinson (The VBA Help)
- Over 2,500 Windows API Functions now available to be added directly to your VBA Project: VBE_Extras 1.7.4.0 enables automatic insertion of over 2,500 Windows API declarations with dependencies, conditional compilation support, and Unicode/ANSI conversion options.
- Code Explorer: VBE_Extras introduces a tree-based Code Explorer dialog for navigating all declarations across loaded VBA projects with goto, rename, and reference-finding capabilities.
- VBE_Extras is now available in Microsoft Visio and Microsoft Project: VBE_Extras version 1.7.4.0 extends full functionality to Microsoft Visio and Project, enabling advanced VBA navigation and refactoring tools in those applications.
- Daniel Pineault (DEVelopers HUT)
- Microsoft Access Built-In Progress Meter / How-To Display Progress Bars in Your Databases: Demonstrates using Access's built-in SysCmd progress meter with wrapper functions for error handling and dynamic message updates during long-running operations.
- Determine When A Microsoft Access Database Was Created: Compares four VBA techniques for retrieving an Access database's creation date — FileSystemObject, DAO container properties, a TableDef's DateCreated, and the hidden MSysObjects table — concluding none is fully reliable and recommending custom metadata instead.
- Colin Riddington (Isladogs on Access)
- Zooming Feature (Stage 2) Rolling Out: Stage 2 extends Access zoom support to continuous forms, popup forms, and report view, while expanding the zoom range to 10%-1000% with limited VBA control.
- Zooming Feature (Stage 1) Now Available: Documents the initial rollout of Access's zoom feature for datasheets, single forms, and print preview with 50%-500% range via ribbon, keyboard shortcuts, and mouse controls.
- Access Bug Summary - June 2026 (IN PROGRESS): Tracks ten June 2026 Access bugs primarily affecting the new zooming feature, including control tip display issues, coordinate mismatches, and performance problems with complex forms.
- Mike Wolfe (NoLongerSet)
- Throwback Thursday: June 18, 2026: Curates classic articles covering combo box techniques, filter manipulation, cascading forms, and custom ListBox implementations from the nolongerset.com archive.
- twinBASIC Update: June 16, 2026: Reports LLVM optimizing compiler support reaching 70% coverage for expected June release, plus bug fixes for x64 array handling and new VB6 migration community activity.
Videos
- Access User Group Recordings (YouTube channel)
- Access Roadmap - Upcoming and Planned Enhancements (41:28): with Maria Barnes
- Alessandro Grimaldi (YouTube channel)
- How much do you know about CurrentDb? (31:44): How much do you know about CurrentDb?
- Richard Rost (YouTube channel)
- Highlight Row (12:00): Highlight Current Row with Conditional Formatting in Microsoft Access Continuous Forms - Fitness 78
- Don't Panic (08:44): Will Your Windows 11 PC Stop Working On June 24th? Will Microsoft Access, Word, Excel Still Run?
- Move Up Down Buttons (10:01): Move Up and Down Buttons for Reordering Records in Microsoft Access - Fitness 77
- Display Order (17:00): User-Controlled Display Order, Sorting, and Renumbering in Microsoft Access - Fitness 76
- Search Key Not Found (40:08): Why Microsoft Access Search Key Not Found Errors Happen And How To Fix Them - QQ 96
- Daniel Pineault (YouTube channel)
- Access Progress Meter (08:31): Microsoft Access Built-In Progress Meter / How-To Display Progress Bars in Your Databases
GitHub Projects
*Changelog summary generated by Claude Opus 4.8.
MCP-Access Last week MCP-Access was busy making sure automated sessions didn't hang; this week it turned to how the forms it builds actually look.
v0.7.45 landed access_build_form, a declarative auto-layout tool that pulls all the coordinate arithmetic out of the LLM and into the MCP — describe a form's title, ordered fields, and action buttons and it computes every position on a canonical 60-twip grid, applies a closed WCAG-safe palette, and assigns tab order, backed by a single design-tokens source of truth, an opt-in snap_to_grid, and four new info-only layout-quality lint rules. v0.7.46 added taste on top of that scaffolding: three curated design directions (theme=despacho|panel|archivo), each a coherent bundle of typeface, modular type scale, dominant-plus-accent palette, spacing density, and an accent header band, with a design guide now reachable via access_tips('design'). It also folded in a two-tone header-band fix and two more info-only lint rules (generic_font and a header-title check rolled into hierarchy) — guidance that nudges without ever changing a verdict.
The throughline: moving Access form quality from per-prompt LLM improvisation to deterministic, taste-encoded construction.
New to Me
This section includes content I discovered this week that has been around for a while.
- Nothing new this week.
Upcoming Access User Group Events
NOTE: Only English-language user group meetings with scheduled guest speakers or topics are listed. For a complete list of upcoming events, visit the Access User Group event calendar.
- [July 1, 2026] Colin Riddington: UI Tips/Tricks and New Access Features
- [July 2, 2026] John Colby: Managing a Team of AI Agents
- [August 5, 2026] Marcus Dieterle: Use the Edge browser control to extend Access
- [August 6, 2026] Tom van Stiphout: Anonymizer for Access Data
- [September 2, 2026] John Mallinson: Working with the Windows API
- [October 7, 2026] Peter Bryant / Andrew Richards: GraphAuthenticator – the ‘New’ Outlook problem solved and a world of possibilities to explore
Access Roadmap
There were no changes made to the roadmap between the Week in Review last week (2026-06-13) and this week (2026-06-20).
The roadmap was last updated May 11, 2026.
Listed below is a snapshot of the official Access Roadmap.
"In Development", "Rolling Out", and "Launched" are Microsoft terms that I pulled straight from the public roadmap. Dates listed are "rollout start" dates.
In Development
AUG 2026: Cascading combo and list boxes with LinkMasterFields/LinkChildFields: Combo boxes and list boxes now support LinkMasterFields/LinkChildFields properties, enabling cascading dropdowns (e.g., Country filters City) without writing VBA code.JUL 2026: Rounded corners on Access form controls: We’re making it easier to give your Access apps a polished, up-to-date feel. With the new CornerRadius property, you can add rounded corners to form controls—bringing a softer, more modern look to your designs.JUN 2026: Zooming for Continuous Forms and Multiple-Items Forms: Access extends zoom capabilities to continuous forms and pop-up forms, building on zoom support already available in tables and queries. Adjust magnification from 10 percent to 500 percent using the slider in the lower-right corner or controls on the ribbon. Keyboard shortcuts are also available, making it easy to quickly change your view and focus on the details that matter most.JUN 2026: Modernize Access Forms and Reports to work well on Large Format Monitors: Remove the 22-inch size limit and modernize Access forms and reports work well on large format monitors and provide responsive behavior for different form factors.MAY 2026: Enable zoom magnification to Microsoft Access for Forms, Tables, Queries: Access will add magnification slider (10% to 500%) in lower right of the application, similar to the feature in Word, PowerPoint, and Excel. It will also be keyboard accessible and available on the ribbon in Access forms, tables, and queries.
Rolling Out
None listed.
Launched
None listed.
Upcoming End-of-Life Dates
Here are the key end-of-life dates Access developers should track:
2024
[JUL 09]SQL Server 2014
2025
[OCT 14]Access 2016|Access 2019|Office 2016|Office 2019[OCT 14]Windows 10[OCT 28]Salesforce ODBC Driver[NOV 11]Windows 11 version 23H2
2026
[JUL 14]SQL Server 2016[OCT 13]Access 2021 | Office 2021[OCT 13]Windows 11 version 24H2
2027
[JAN 12]Windows Server 2016[MAR 01]Auto-migration of Classic Outlook begins for Enterprise users (originally scheduled for April 2026, but postponed to March 2027)[OCT 12]SQL Server 2017
2029
[JAN 09]Windows Server 2019[OCT 09]Access 2024 | Outlook 2024[OCT 09(or later)]Classic Outlook- See "Edit 8/12/2024" at top of this article for official clarification that "both perpetual and subscription [i.e., MS 365] versions of Outlook will be supported until 2029"
- Support for Classic Outlook is guaranteed at least through 9 Oct 2029; it may be extended beyond this date
2030
[JAN 08]SQL Server 2019
2031
[OCT 14]Windows Server 2022
2033
[JAN 11]SQL Server 2022
2034
[OCT 10]Windows Server 2025
Ongoing
- Microsoft 365 (with subscription)
Date TBD
- Complete removal of VBScript from Windows OS (Microsoft Announces the Death of VBScript)